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

You have four on-premises Microsoft SQL Server data sources as described in the following table.

You plan to create three Azure data factories that will interact with the data sources as described in the following table.

You need to deploy Microsoft Data Management Gateway to support the Azure Data Factory deployment. The solution must use new servers to host the instances of Data Management Gateway.
What is the minimum number of new servers and data management gateways you should you deploy? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Explanation

Box 1: 3
Box 2: 3
Considerations for using gateway

You have a pipeline that contains an input dataset in Microsoft Azure Table Storage and an output dataset in Azure Blob storage. You have the following JSON data.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON data.
NOTE: Each correct selection is worth one point.

정답:

Explanation

Box 1: Every three days at 10.00
anchorDateTime defines the absolute position in time used by the scheduler to compute dataset slice boundaries.
"frequency": "<Specifies the time unit for data slice production. Supported frequency: Minute, Hour, Day, Week, Month>",
"interval": "<Specifies the interval within the defined frequency. For example, frequency set to 'Hour' and interval set to 1 indicates that new data slices should be produced hourly> Box 2: Every minute up to three times.
retryInterval is the wait time between a failure and the next attempt. This setting applies to present time. If the previous try failed, the next try is after the retryInterval period.
Example: 00:01:00 (1 minute)
Example: If it is 1:00 PM right now, we begin the first try. If the duration to complete the first validation check is 1 minute and the operation failed, the next retry is at 1:00 + 1min (duration) + 1min (retry interval) =
1:02 PM.
For slices in the past, there is no delay. The retry happens immediately.
retryTimeout is the timeout for each retry attempt.
maximumRetry is the number of times to check for the availability of the external data.

Users report that when they access data that is more than one year old from a dashboard, the response time is slow.
You need to resolve the issue that causes the slow response when visualizing older data. What should you do?

• A.Process the event hub data first, and then process the older data on demand.
• B.Aggregate the older data by time, and then save the aggregated data to reference data streams.
• C.Process the older data on demand first, and then process the event hub data.
• D.Store all of the data from the event hub in a single partition.

You are designing an Internet of Thing: (IoT) solution intended to identify trends. The solution requires the realtime analysis of data originating from sensors. The results of the analysis will be stored in a SQL database.
You need to recommend a data processing solution that uses the Transact-SQL language.
Which data processing solution should you recommend?

• A.Microsoft Azure Machine Learning
• B.Microsoft SQL Server Integration Services (SSIS)
• C.Microsoft Azure HDInsight Hadoop clusters
• D.Microsoft Azure Stream Analytics

You deploy a Microsoft Azure SQL database.
You create a job to upload customer data to the database.
You discover that the job cannot connect to the database and fails.
You verify that the database runs successfully in Azure.
You need to run the job successfully.
What should you create?

• A.a virtual network
• B.a network security group (NSG)
• C.a firewall rule
• D.a virtual network rule