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

You need to create a new Microsoft Azure data factory by using Azure PowerShell. The data factory will have a pipeline that copies data to and from Azure Storage.
Which four cmdlets should you use in sequence? To answer, move the appropriate cmdlets from the list of cmdlets to the answer area and arrange them in the correct order.

정답:

Explanation

Perform these operations in the following order:
* Create a data factory.
* Create linked services.
* Create datasets.
* Create a pipeline.
Step 1: New-AzureRMDataFactory
Create a data factory
The New-AzureRmDataFactory cmdlet creates a data factory with the specified resource group name and location.
Step 2: New-AzureRMDataFactoryLinkedService
Create linked services in a data factory to link your data stores and compute services to the data factory.
The New-AzureRmDataFactoryLinkedService cmdlet links a data store or a cloud service to Azure Data Factory.
Step 3: New-AzureRMDataFactoryDataset
You define a dataset that represents the data to copy from a source to a sink. It refers to the Azure Storage linked service you created in the previous step.
The New-AzureRmDataFactoryDataset cmdlet creates a dataset in Azure Data Factory.
Step 4: New-AzureRMDataFactoryPipeline
You create a pipeline.
The New-AzureRmDataFactoryPipeline cmdlet creates a pipeline in Azure Data Factory.
References:
https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-powershell
https://docs.microsoft.com/en-us/powershell/module/azurerm.datafactories/new-azurermdatafactory

You need to automate the creation of a new Microsoft Azure data factory.
What are three possible technologies that you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point

• A.the REST API
• B.the SOAP service
• C.T-SQL statements
• D.the Microsoft .NET framework class library
• E.Azure PowerShell cmdlets

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

You have a Microsoft Azure Stream Analytics job that contains several pipelines.
The Stream Analytics job is configured to trigger an alert when the sale of products in specific categories exceeds a specified threshold.
You plan to change the product-to-category mappings next month to meet future business requirements.
You need to create the new product-to-category mappings to prepare for the planned change. The solution must ensure that the Stream Analytics job only uses the new product-to-category mappings when the mappings are ready to be activated.
Which naming structure should you use for the file that contains the product-to-category mappings?

• A.Use any date before the day the categories become active.
• B.Use any date after the day the file becomes active.
• C.Use the current date and time.
• D.Use the date and hour that the categories are to become active.

Your company deploys thousands of sensors.
You plan to join the data from the sensors by using Azure Data Factory. The reference data file refreshes every
30 minutes.
You need to include the path to the reference data in Data Factory.
Which path should you include?

• A.products/{time}/product_list.json
• B.products/{batch}/product_listjson
• C.products/{sensor_name}/product_list.json
• D.products/{date}/{time}/product_listjson