Practical 70-776 Dumps Questions 2021

NEW QUESTION 1
You use Microsoft Azure Data Lake Store as the default storage for an Azure HDInsight cluster.
You establish an SSH connection to the HDInsight cluster.
You need to copy files from the HDInsight cluster to the Data LakeStore. Which command should you use?

• A. AzCopy
• B. hdfs dfs
• C. hadoop fs
• D. AdlCopy

Answer: D

NEW QUESTION 2
You have a Microsoft Azure Data Lake Analytics service.
You need to store a list of milltiple-character string values in a single column and to use a cross apply explode expression to output the values.
Which type of data should you use in a U-SQL query?

• A. SQL.MAP
• B. SQL.ARRAY
• C. string
• D. byte [ ]

Answer: B

NEW QUESTION 3
HOTSPOT
You have a Microsoft Azure Data Factory version 2 (V2) service.
You need to deploy a linked service to an existing database in Azure SQL Data Warehouse.
How should you complete the JSON snippet? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 4
You plan to deploy a Microsoft Azure virtual machine that will a host data warehouse. The data warehouse will contain a 10-TB database.
You need to provide the fastest read and writes times for the database. Which disk configuration should you use?

• A. storage pools with mirrored disks
• B. RAID 5 volumes
• C. spanned volumes
• D. stripped volumes
• E. storage pools with striped disks

Answer: E

NEW QUESTION 5
Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You are migrating an existing on-premises data warehouse named LocalDW to Microsoft Azure. You will use an Azure SQL data warehouse named AzureDW for data storage and an Azure Data Factory named AzureDF for extract, transformation, and load (ETL) functions.
For each table in LocalDW, you create a table in AzureDW.
On the on-premises network, you have a Data Management Gateway.
Some source data is stored in Azure Blob storage. Some source data is stored on an on-premises Microsoft SQL Server instance. The instance has a table named Table1.
After data is processed by using AzureDF, the data must be archived and accessible forever. The archived data must meet a Service Level Agreement (SLA) for availability of 99 percent. If an Azure region fails, the archived data must be available for reading always. The storage solution for the archived data must minimize costs.
End of repeated scenario.
You need to define the schema of Table1 in AzureDF. What should you create?

• A. a gateway
• B. a linked service
• C. a dataset
• D. a pipeline

Answer: C

NEW QUESTION 6
You need to define an input dataset for a Microsoft Azure Data Factory pipeline.
Which properties should you include when you define the dataset?

• A. name, type, typeProperties, and availability
• B. name, typeProperties, structure, and availability
• C. name, policy, structure, and external
• D. name, type, policy, and structure

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-create-datasets

NEW QUESTION 7
Note: This question is part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You are migrating an existing on-premises data warehouse named LocalDW to Microsoft Azure. You will use an Azure SQL data warehouse named AzureDW for data storage and an Azure Data Factory named AzureDF for extract, transformation, and load (ETL) functions.
For each table in LocalDW, you create a table in AzureDW.
On the on-premises network, you have a Data Management Gateway.
Some source data is stored in Azure Blob storage. Some source data is stored on an on-premises Microsoft SQL Server instance. The instance has a table named Table1.
After data is processed by using AzureDF, the data must be archived and accessible forever. The archived data must meet a Service Level Agreement (SLA) for availability of 99 percent. If an Azure region fails, the archived data must be available for reading always. The storage solution for the archived data must minimize costs.
End of repeated scenario.
You need to configure an activity to move data from blob storage to AzureDW. What should you create?

• A. a pipeline
• B. a linked service
• C. an automation runbook
• D. a dataset

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-azure-blob-connector

NEW QUESTION 8
You have a Microsoft Azure SQL data warehouse. You have an Azure Data Lake Store that contains data from ORC, RC, Parquet, and delimited text files.
You need to load the data to the data warehouse in the least amount of time possible. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Use Microsoft SQL Server Integration Services (SSIS) to enumerate from the Data Lake Store by using a for loop.
• B. Use AzCopy to export the files from the Data Lake Store to Azure Blob storage.
• C. For each file in the loop, export the data to Parallel Data Warehouse by using a Microsoft SQL Server Native Client destination.
• D. Load the data by executing the CREATE TABLE AS SELECT statement.
• E. Use bcp to import the files.
• F. In the data warehouse, configure external tables and external file formats that correspond to the Data Lake Store.

Answer: DF

Explanation:
References:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lake-store

NEW QUESTION 9
DRAG DROP
You need to design a Microsoft Azure solution to analyze text from a Twitter data stream. The solution must identify a sentiment score of positive, negative, or neutral for the tweets.
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:

NEW QUESTION 10
You plan to capture the output from a group of 500 IoT devices that produce approximately 10 GB of
data per hour by using Microsoft Azure Stream Analytics. The data will be retained for one year.
Once the data is processed, it will be stored in Azure, and then analyzed by using an Azure HDInsight cluster.
You need to select where to store the output data from Stream Analytics. The solution must minimize costs.
What should you select?

• A. Azure Table Storage
• B. Azure SQL Database
• C. Azure Blob storage
• D. Azure SQL Data Warehouse

Answer: C

NEW QUESTION 11
You have a Microsoft Azure Data Lake Analytics service. You plan to configure diagnostic logging.
You need to use Microsoft Operations Management Suite (OMS) to monitor the IP addresses that are used to access the Data Lake Store.
What should you do?

• A. Stream the request logs to an event hub.
• B. Send the audit logs to Log Analytics.
• C. Send the request logs to Log Analytics.
• D. Stream the audit logs to an event hub.

Answer: B

Explanation:
References:
https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-diagnostic-logs https://docs.microsoft.com/en-us/azure/security/azure-log-audit

NEW QUESTION 12
DRAG DROP
You have a Microsoft Azure SQL data warehouse named DW1. Data is located to DW1 once daily at 01:00.
A user accidentally deletes data from a fact table in DW1 at 09:00.
You need to recover the lost data. The solution must prevent the need to change any connection strings and must minimize downtime.
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:

NEW QUESTION 13
You have a Microsoft Azure Data Lake Store that contains a folder named /Users/User1 and an Azure
Active Directory account named User1.
You need to provide access to the Data Lake Store to meet the following requirements:
• Grant User1 read and list access to /Users/User1.
• Prevent User1 from viewing the contents in /Users.
• Minimize the number of permissions granted to User1. What should you do?

• A. Grant User1 Execute permissions to /Users and /Users/User1.
• B. Grant User1 Read permissions to /Users folder and /Users/User1.
• C. Grant User1 Read permissions to Users/User1.
• D. Grant User1 Execute permissions to /User
• E. Grant Userl Read & Execute permissions to /Users/User1.

Answer: D

NEW QUESTION 14
DRAG DROP
You plan to develop a solution for real-time sentiment analysis of Twitter data.
You need to create a Microsoft Azure Stream Analytics job query to count the number of tweets during a period.
Which Window function should you use for each requirement? To answer, drag the appropriate functions to the correct requirements. Each function 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:
References:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions

NEW QUESTION 15
You are developing an application that uses Microsoft Azure Stream Analytics.
You have data structures that are defined dynamically.
You want to enable consistency between the logical methods used by stream processing and batch processing.
You need to ensure that the data can be integrated by using consistent data points. What should you use to process the data?

• A. a vectorized Microsoft SQL Server Database Engine
• B. directed acyclic graph (DAG)
• C. Apache Spark queries that use updateStateByKey operators
• D. Apache Spark queries that use mapWithState operators

Answer: D

NEW QUESTION 16
You have a Microsoft Azure SQL data warehouse.
You need to configure Data Warehouse Units (DWUs) to ensure that you have six compute nodes. The solution must minimize costs.
Which value should set for the DWUs?

• A. DW200
• B. DW400
• C. DW600
• D. DW1000

Answer: C

Explanation:
References:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute- overview

NEW QUESTION 17
DRAG DROP
You have a Microsoft Azure SQL data warehouse.
Users discover that reports running in the data warehouse take longer than expected to complete. You need to review the duration of the queries and which users are running the queries currently. Which dynamic management view should you review for each requirement? To answer, drag the appropriate dynamic management views to the correct requirements. Each dynamic management view 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:
References:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-pdw-exec-requests-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-pdw-exec-sessions-transact-sql