Download Perform Big Data Engineering on Microsoft Cloud Services (beta).testkings.70-776.2018-09-30.1e.26q.vcex

Download Dump

File Info

Exam Perform Big Data Engineering on Microsoft Cloud Services (beta)
Number 70-776
File Name Perform Big Data Engineering on Microsoft Cloud Services (beta).testkings.70-776.2018-09-30.1e.26q.vcex
Size 378 Kb
Posted September 30, 2018
Downloaded 1



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%





Demo Questions

Question 1
Note: This question is part of 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 table named Table1 that contains 3 billion rows. Table1 contains data from the last 36 months. 
At the end of every month, the oldest month of data is removed based on a column named DateTime. 
You need to minimize how long it takes to remove the oldest month of data. 
Solution: You specify DateTime as the hash distribution column.
Does this meet the goal?

  • A: Yes
  • B: No



Question 2
Note: This question is part of 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 table named Table1 that contains 3 billion rows. Table1 contains data from the last 36 months. 
At the end of every month, the oldest month of data is removed based on a column named DateTime. 
You need to minimize how long it takes to remove the oldest month of data. 
Solution: You implement range partitioning based on the year and the month.
Does this meet the goal?

  • A: Yes
  • B: No



Question 3
Note: This question is part of 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 table named Table1 that contains 3 billion rows. Table1 contains data from the last 36 months. 
At the end of every month, the oldest month of data is removed based on a column named DateTime. 
You need to minimize how long it takes to remove the oldest month of data. 
Solution: You implement round robin for table distribution.
Does this meet the goal?

  • A: Yes
  • B: No



Question 4
Note: This question is part of 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 are troubleshooting a slice in Microsoft Azure Data Factory for a dataset that has been in a waiting state for the last three days. The dataset should have been ready two days ago. 
The dataset is being produced outside the scope of Azure Data Factory. The dataset is defined by using the following JSON code. 

  

You need to modify the JSON code to ensure that the dataset is marked as ready whenever there is data in the data store. 
Solution: You change the interval to 24.
Does this meet the goal?

  • A: Yes
  • B: No



Question 5
Note: This question is part of 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 are troubleshooting a slice in Microsoft Azure Data Factory for a dataset that has been in a waiting state for the last three days. The dataset should have been ready two days ago. 
The dataset is being produced outside the scope of Azure Data Factory. The dataset is defined by using the following JSON code. 

  

You need to modify the JSON code to ensure that the dataset is marked as ready whenever there is data in the data store. 
Solution: You add conditions to the policy.
Does this meet the goal?

  • A: Yes
  • B: No



Question 6
Note: This question is part of 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 are troubleshooting a slice in Microsoft Azure Data Factory for a dataset that has been in a waiting state for the last three days. The dataset should have been ready two days ago. 
The dataset is being produced outside the scope of Azure Data Factory. The dataset is defined by using the following JSON code. 

 
 
You need to modify the JSON code to ensure that the dataset is marked as ready whenever there is data in the data store. 
Solution: You change the external attribute to true.
Does this meet the goal?

  • A: Yes
  • B: No



Question 7
You are designing a data loading process for a Microsoft Azure SQL data warehouse. Data will be loaded to Azure Blob storage, and then the data will be loaded to the data warehouse. 
Which tool should you use to load the data to Azure Blob storage?

  • A: AdlCopy
  • B: bcp
  • C: FTP
  • D: AzCopy



Question 8
You have a Microsoft Azure SQL data warehouse to which 1,000 Data Warehouse Units (DWUs) are allocated. 
You plan to load 10 million rows of data to the data warehouse. 
You need to load the data in the least amount of time possible. The solution must ensure that queries against the new data execute as quickly as possible. 
What should you use to optimize the data load?

  • A: resource classes
  • B: resource pools
  • C: MAXDOP
  • D: Resource Governor



Question 9
You have a Microsoft Azure SQL data warehouse stored in geo-redundant storage. 
You experience a regional outage. 
You plan to recover the database to a new region. 
You need to get a list of the backup files that can be restored to the new region. 
Which cmdlet should you run?

  • A: Get-AzureRmSqlDatabase
  • B: Get-AzureRmSqlDatabaseGeoBackup
  • C: Get-AzureRmSqlDatabaseReplicationLink
  • D: Get-AzureRmSqlDatabaseRestore Points



Question 10
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?

  • A: the export and import of BACPAC files
  • B: SQL Server Integration Services (SSIS)
  • C: SQL Server backup and restore
  • D: SQL Server snapshot replication









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset