PrepAway - Latest Free Exam Questions & Answers

Category: 70-776

Briefing 70-776: Performing Big Data Engineering on Microsoft Cloud Services (beta)

You need to implement a process to replicate the on-pre…

You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains
100 TB of data. The data is partitioned by month. One TB of data is added to the data warehouse each month.
You create a Microsoft Azure SQL data warehouse and copy the on-premises data to the data warehouse.
You need to implement a process to replicate the on-premises data warehouse to the Azure SQL data
warehouse. The solution must support daily incremental updates and must provide error handling.
What should you use?

Which two actions should you perform?

You have an on-premises data warehouse that uses Microsoft SQL Server 2016. All the data in the data
warehouse comes from text files stored in Azure Blob storage. The text files are imported into the data
warehouse by using SQL Server Integration Services (SSIS). The text files are not transformed.
You need to migrate the data to an Azure SQL 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.

Which dynamic management view should you review for eac…

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.
Select and Place:

You need to get the following information: – The top 10…

DRAG DROP
You are monitoring a Microsoft Azure SQL data warehouse.
You need to get the following information:
– The top 10 longest running queries
– The distributed query plan for a specific query
Which dynamic management view should you use for each piece of information? To answer, drag the
appropriate dynamic management views to the correct pieces of information. 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.
Select and Place:

Which three actions should you perform in sequence?

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.
Select and Place:

What is the maximum number of streaming units that will…

HOTSPOT
You plan to implement a Microsoft Azure Stream Analytics job to track the data from IoT devices. You will have
the following two jobs:
– Job1 will contain a query that has one non-partitioned step.
– Job2 will contain a query that has two steps. One of the steps is partitioned.
What is the maximum number of streaming units that will be consumed per job? To answer, select the
appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

You need to create a dataset in Microsoft Azure Data Fa…

DRAG DROP
You need to create a dataset in Microsoft Azure Data Factory that meets the following requirements:
Receives data from Azure Data Factory
Uses Azure Blob storage
Writes data to a blob storage path based on the current year and month
How should you complete the JSON code? To answer, drag the appropriate values to the correct targets. Each
value 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.
Select and Place:


Page 1 of 712345...Last »