070-475 무료 덤프문제 온라인 액세스

You have a Microsoft Azure Data Factory that loads data to an analytics solution.
You receive an alert that an error occurred during the last processing of a data stream.
You debug the problem and solve an error.
You need to process the data stream that caused the error.
What should you do?

• A.From PowerShell, run the Set-AzureRmDataFactorySliceStatus cmdlet.
• B.From PowerShell, run the Resume-AzureRmDataFactoryPipeline cmdlet.
• C.From Azure Cloud Shell, run the az batch job enable command.
• D.From Azure Cloud Shell, run the az dla job command.

You plan to design a solution to gather data from 5,000 sensors that are deployed to multiple machines. The sensors generate events that contain data on the health status of the machines.
You need to create a new Microsoft Azure event hub to collect the event data.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

You implement DB2.
You need to configure the tables in DB2 to host the data from DB1. The solution must meet the requirements for DB2.
Which type of table and history table storage should you use for the tables? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Explanation

From Scenario: Relecloud plans to implement a data warehouse named DB2.
Box 1: Temporal table
From Scenario:
Relecloud identifies the following requirements for DB2:
Users must be able to view previous versions of the data in DB2 by using aggregates.
DB2 must be able to store more than 40 TB of data.
A system-versioned temporal table is a new type of user table in SQL Server 2017, designed to keep a full history of data changes and allow easy point in time analysis. A temporal table also contains a reference to another table with a mirrored schema. The system uses this table to automatically store the previous version of the row each time a row in the temporal table gets updated or deleted. This additional table is referred to as the history table, while the main table that stores current (actual) row versions is referred to as the current table or simply as the temporal table.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the states goals. Some question sets might have more than one correct solution, while the others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Apache Spark system that contains 5 TB of data.
You need to write queries that analyze the data in the system. The queries must meet the following requirements:
* Use static data typing.
* Execute queries as quickly as possible.
* Have access to the latest language features.
Solution: You write the queries by using Scala.

• A.No
• B.Yes

You are using a Microsoft Azure Data Factory pipeline to copy data to an Azure SQL database.
You need to prevent the insertion of duplicate data for a given dataset slice.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Set the External property to true.
• B.Manually delete the duplicate data before running the pipeline activity.
• C.Remove the duplicates in post-processing.
• D.Set the SqlWriterCleanupScript property to true.
• E.Add a column named SliceIdentifierColumnName to the output dataset.