Certified 70-475 Exam Dumps 2021

NEW QUESTION 1
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/{date}/{time}/product_listjson
• B. products/{sensor_name}/product_list.json
• C. products/{batch}/product_listjson
• D. products/{time}/product_list.json

Answer: A

NEW QUESTION 2
Your company has a Microsoft Azure environment that contains an Azure HDInsight Hadoop cluster and an Azure SQL data warehouse. The Hadoop cluster contains text files that are formatted by using UTF-8 character encoding.
You need to implement a solution to ingest the data to the SQL data warehouse from the Hadoop cluster. The solution must provide optimal read performance for the data after ingestion.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation: SQL Data Warehouse supports loading data from HDInsight via PolyBase. The process is the same as loading data from Azure Blob Storage - using PolyBase to connect to HDInsight to load data.
Use PolyBase and T-SQL Summary of loading process: Recommendations
Create statistics on newly loaded data. Azure SQL Data Warehouse does not yet support auto create or auto update statistics. In order to get the best performance from your queries, it's important to create statistics on all columns of all tables after the first load or any substantial changes occur in the data.

NEW QUESTION 3
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.
You have a Microsoft Azure subscription that includes Azure Data Lake and Cognitive Services. An administrator plans to deploy an Azure Data Factory.
You need to ensure that the administrator can create the data factory. Solution: You add the user to the Owner role.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 4
You have an Apache Storm cluster.
You need to ingest data from a Kafka queue.
Which component should you use to consume data emitted from Kaka?

• A. Flume
• B. a bolt
• C. a spout
• D. a Microsoft Azure Service Bus queue

Answer: C

Explanation: To perform real-time computation on Storm, we create “topologies.” A topology is a graph of a computation, containing a network of nodes called “Spouts” and “Bolts.” In a Storm topology, a Spout is the source of data streams and a Bolt holds the business logic for analyzing and processing those streams.
The org.apache.storm.kafka.KafkaSpout component reads data from Kafka. Example:

References:
https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-apache-storm-with-kafka https://hortonworks.com/blog/storm-kafka-together-real-time-data-refinery/

NEW QUESTION 5
You have a Microsoft Azure Machine Learning Solution that contains several Azure Data Factory pipeline jobs.
You discover that the jobs for a dataset named CustomerSalesData fails. You resolve the issue that caused the job to fail.
You need to rerun the slices for CustomerSalesData. What should you do?

• A. Run the Set-AzureRMDataFactorySliceStatus cmdlet and specify the–Status Retry parameter.
• B. Run the Set-AzureRMDataFactorySliceStatus cmdlet and specify the–Status PendingExecution parameter.
• C. Run the Resume-AzureRMDataFactoryPipeline cmdlet and specify the–Status Retry parameter.
• D. Run the Resume-AzureRMDataFactoryPipeline cmdlet and specify the–Status PendingExecution parameter.

Answer: B

NEW QUESTION 6
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 Azure Cloud Shell, run the az dla job command.
• B. From Azure Cloud Shell, run the az batch job enable command.
• C. From PowerShell, run the Resume-AzureRmDataFactoryPipeline cmdlet.
• D. From PowerShell, run the Set-AzureRmDataFactorySliceStatus cmdlet.

Answer: D

Explanation: ADF operates on data in batches known as slices. Slices are obtained by querying data over a date-time window—for example, a slice may contain data for a specific hour, day, or week.
References:
https://blogs.msdn.microsoft.com/bigdatasupport/2021/08/31/rerunning-many-slices-and-activities-in-azure-data

NEW QUESTION 7
You are developing a solution to ingest data in real-time from manufacturing sensors. The data will be archived. The archived data might be monitored after it is written.
You need to recommend a solution to ingest and archive the sensor data. The solution must allow alerts to be sent to specific users as the data is ingested.
What should you include in the recommendation?

• A. a Microsoft Azure notification hub and an Azure function
• B. a Microsoft Azure notification hub an Azure logic app
• C. a Microsoft Azure Stream Analytics job that outputs data to an Apache Storm cluster in AzureHDInsight
• D. a Microsoft Azure Stream Analytics job that outputs data to Azure Cosmos DB

Answer: C

NEW QUESTION 8
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 Microsoft Azure Data Lake job.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 9
You need to recommend a data analysis solution for 20,000 Internet of Things (IoT) devices. The solution must meet the following requirements:
• Each device must be identified by using its own credentials.
• Each device must be able to route data to multiple endpoints.
• The solution must require the minimum amount of customized code. What should you recommend?

• A. Microsoft Azure Notification Hubs
• B. Microsoft Azure IoT Hub
• C. Microsoft Azure Service Bus
• D. Microsoft Azure Event Hubs

Answer: D

NEW QUESTION 10
Which technology should you recommend to meet the technical requirement for analyzing the social media data?

• A. Azure Stream Analytics
• B. Azure Data Lake Analytics
• C. Azure Machine Learning
• D. Azure HDInsight Storm clusters

Answer: A

Explanation: Azure Stream Analytics is a fully managed event-processing engine that lets you set up real-time analytic computations on streaming data.
Scalability
Stream Analytics can handle up to 1 GB of incoming data per second. Integration with Azure Event Hubs and Azure IoT Hub allows jobs to ingest millions of events per second coming from connected devices, clickstreams, and log files, to name a few. Using the partition feature of event hubs, you can partition computations into logical steps, each with the ability to be further partitioned to increase scalability.

NEW QUESTION 11
You have a large datacenter.
You plan to track the hardware failure notifications that occur in the datacenter. You expect to collect approximated 2 TB of data each month. You need to recommend a solution that meets the following requirements:
• Operators must be informed by email as soon as a hardware failure occurs.
• All event data associated with a hardware failure must be preserved for 24 months. The solution must minimize costs.

Answer:

Explanation:

NEW QUESTION 12
The settings used for slice processing are described in the following table.

If the slice processing fails, you need to identify the number of retries that will be performed before the slice execution status changes to failed.
How many retries should you identify?

• A. 2
• B. 3
• C. 5
• D. 6

Answer: C

NEW QUESTION 13
You are building a streaming data analysis solution that will process approximately 1 TB of data weekly. You plan to use Microsoft Azure Stream Analytics to create alerts on real-time data. The data must be preserved for deeper analysis at a later date.
You need to recommend a storage solution for the alert data. The solution must meet the following requirements:
Support scaling up without any downtime
Minimize data storage costs.
What should you recommend using to store the data?

• A. Azure Data Lake
• B. Azure SQL Database
• C. Azure SQL Data Warehouse
• D. Apache Kafka

Answer: A

NEW QUESTION 14
You plan to deploy Microsoft Azure HDInsight clusters for business analytics and data pipelines. The clusters must meet the following requirements:
Business users must use a language that is similar to SQL.
The authoring of data pipelines must occur in a dataflow language. You need to identify which language must be used for each requirement.
Which languages should you identify? To answer, drag the appropriate languages to the correct requirements. Each language may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Answer:

Explanation:

NEW QUESTION 15
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.
You have a Microsoft Azure subscription that includes Azure Data Lake and Cognitive Services. An administrator plans to deploy an Azure Data Factory.
You need to ensure that the administrator can create the data factory. Solution: You add the user to the Data Factory Contributor role. Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 16
Your company plans to deploy a web application that will display marketing data to its customers. You create an Apache Hadoop cluster in Microsoft Azure HDInsight and an Azure data factory. You need to implement a linked service to the cluster.
Which JSON specification should you use to create the linked service?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: B

NEW QUESTION 17
You have a Microsoft Azure data factory.
You assign administrative roles to the users in the following table.

You discover that several new data factory instances were created.
You need to ensure that only User5 can create a new data factory instance.
Which two roles should you change? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. User2 to Reader
• B. User3 to Contributor
• C. User1 to Reader
• D. User4 to Contributor
• E. User5 to Administrator

Answer: AC