Online Access Free 070-475 Practice Test

Your Microsoft Azure subscription contains several data sources that use the same XML schema. You plan to process the data sources in parallel.
You need to recommend a compute strategy to minimize the cost of processing the data sources. What should you recommend including in the compute strategy?

• A.Azure Batch
• B.a Windows HPC cluster in Azure
• C.a Linux HPC cluster in Azure
• D.Microsoft SQL Server Integration Services (SSIS) on an Azure virtual machine

Your company builds hardware devices that contain sensors. You need to recommend a solution to process the sensor data and. What should you include in the recommendation?

• A.Microsoft Azure Event Hubs
• B.Microsoft Azure IoT Hub
• C.Microsoft Azure Notification Hubs
• D.API apps in Microsoft Azure App Service

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 stated goals. Some question sets might have more than one correct solution, while 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.
Your company has multiple databases that contain millions of sales transactions.
You plan to implement a data mining solution to identity purchasing fraud.
You need to design a solution that mines 10 terabytes (TB) of sales data. The solution must meet the following requirements:
* Run the analysis to identify fraud once per week.
* Continue to receive new sales transactions while the analysis runs.
* Be able to stop computing services when the analysis is NOT running.
Solution: You create a Cloudera Hadoop cluster on Microsoft Azure virtual machines.
Does this meet the goal?

• A.Yes
• B.No

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 stated 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 plan to deploy a Microsoft Azure SQL data warehouse and a web application.
The data warehouse will ingest 5 TB of data from an on-premises Microsoft SQL Server database daily. The web application will query the data warehouse.
You need to design a solution to ingest data into the data warehouse.
Solution: You use AzCopy to transfer the data as text files from SQL Server to Azure Blob storage, and then you use PolyBase to run Transact-SQL statements that refresh the data warehouse database.
Does this meet the goal?

• A.Yes
• B.No

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.

Correct Answer:

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