NEW QUESTION 1
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 2
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 3
The health tracking application uses the features of a live dashboard to provide historical and trending data based on the users activities.
You need to recommend which processing model must be used to process the following types of data: The top three activities per user on rainy days
The top three activities per user during the last 24 hours
The top activities per geographic region during last 24 hours
The most common sequences of three activities in a row for all of the users
Which processing model should you recommend for each date type? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 4
You have a Microsoft Azure HDInsight cluster for analytics workloads. You have a C# application on a local computer.
You plan to use Azure Data Factory to run the C# application in Azure.
You need to create a data factory that runs the C# application by using HDInsight.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Answer:

Explanation:

NEW QUESTION 5
You need to recommend a data handling solution to support the planned changes to the dashboard. The solution must meet the privacy requirements.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

• A. anonymization
• B. encryption
• C. obfuscation
• D. compression

Answer: C

NEW QUESTION 6
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 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 SQL Server Integration Services (SSIS) to transfer data from SQL Server to Azure SQL Data Warehouse.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

Explanation: Integration Services (SSIS) is a powerful and flexible Extract Transform and Load (ETL) tool that supports complex workflows, data transformation, and several data loading options.
The main drawback is speed. We should use Polybase instead.
References: https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services

NEW QUESTION 7
You are building an Azure Analysis Services cube.
The source data for the cube is located on premises in a Microsoft SQL Server database. You need to ensure that the Azure Analysis Services service can access the source data. What should you deploy to your Azure subscription?

• A. a site-to-site VPN
• B. Azure Data Factory
• C. a network gateway in Azure
• D. a data gateway in Azure

Answer: D

Explanation: Connecting to on-premises data sources from and Azure AS server require an On-premises gateway.

References:
https://azure.microsoft.com/en-in/blog/on-premises-data-gateway-support-for-azure-analysis-services/

NEW QUESTION 8
You are automating the deployment of a Microsoft Azure Data Factory solution. The data factory will interact with a file stored in Azure Blob storage.
You need to use the REST API to create a linked service to interact with the file.
How should you complete the request body? To answer, drag the appropriate code elements to the correct locations. Each code may be used once, more than once, or not at all. You may need to drag the slit bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 9
You have an Apache Storm cluster.
The cluster will ingest data from a Microsoft Azure event hub.
The event hub has the characteristics described in the following table.

You are designing the Storm application topology.
You need to ingest data from all of the partitions. The solution must maximize the throughput of the data ingestion.
Which setting should you use?

• A. Partition Count
• B. Message Retention
• C. Partition Key
• D. Shared access policies

Answer: A

NEW QUESTION 10
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 rule
• B. a network security group (NSG)
• C. a firewall rule
• D. a virtual network

Answer: C

Explanation: If the application persistently fails to connect to Azure SQL Database, it usually indicates an issue with one of the following:
Firewall configuration. The Azure SQL database or client-side firewall is blocking connections to Azure SQL Database.
Network reconfiguration on the client side: for example, a new IP address or a proxy server.
User error: for example, mistyped connection parameters, such as the server name in the connection string. References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-troubleshoot-common-connection-issues

NEW QUESTION 11
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

Answer: A

Explanation: If you need the best performance, then use PolyBase to import data into Azure SQL warehouse.
Note: Often the speed of migration is an overriding concern compared to ease of setup and maintainability,
particularly when there’s a large amount of data to move. Optimizing purely for speed, a source controlled differentiated approach relying on bcp to export data to files, efficiently moving the files to Azure Blob storage, and using the Polybase engine to import from blob storage works best.
References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-migrate-data

NEW QUESTION 12
You are designing an application that will perform real-time processing by using Microsoft Azure Stream Analytics.
You need to identify the valid outputs of a Stream Analytics job.
What are three possible outputs that you can use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. Microsoft Power BI
• B. Azure SQL Database
• C. a Hive table in Azure HDInsight
• D. Azure Blob storage
• E. Azure Redis Cache

Answer: ABD

Explanation: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-outputs

NEW QUESTION 13
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 Java.

• A. Yes
• B. No

Answer: B

NEW QUESTION 14
You need to implement a security solution for Microsoft Azure SQL database. The solution must meet the following requirements:
Ensure that users can see the data from their respective department only.
Prevent administrators from viewing the data.
Which feature should you use for each requirement? To answer, drag the appropriate features to the correct requirements. Each feature 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.
NOTE: Each correct selection is worth one point.

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 has 2000 servers.
You plan to aggregate all of the log files from the servers in a central repository that uses Microsoft Azure HDInsight. Each log file contains approximately one million records. All of the files use the .log file name extension.
The following is a sample of the entries in the log files.
20:26:41 SampleClass3 (ERROR) verbose detail for id 1527353937
In Apache Hive, you need to create a data definition and a query capturing tire number of records that have an error level of [ERROR].
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation: Box 1: table
Box 2: /t
Apache Hive example:
CREATE TABLE raw (line STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY 't' LINES TERMINATED BY 'n';
Box 3: count(*)
Box 4: '*.log'

NEW QUESTION 17
You are designing an Internet of Things (IoT) solution intended to identify trends. The solution requires the
real-time 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 Stream Analytics
• B. Microsoft Azure HDInsight Spark clusters
• C. Microsoft Azure Event Hubs
• D. Microsoft Azure HDInsight Hadoop clusters

Answer: A

Explanation: For your Internet of Things (IoT) scenarios that use Event Hubs, Azure Stream Analytics can serve as a possible first step to perform near real-time analytics on telemetry data. Just like Event Hubs, Steam Analytics supports the streaming of millions of event per second. Unlike a standard database, analysis is performed on data in motion. This streaming input data can also be combined with reference data inputs to perform lookups or do correlation to assist in unlocking business insights. It uses a SQL-like language to simplify the analysis of data inputs and detect anomalies, trigger alerts or transform the data in order to create valuable outputs