Microsoft 70-776 - Perform Big Data Engineering on Microsoft Cloud Services Exam
Page: 3 / 17
Total 83 questions
Question #11 (Topic: Topic 1)
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?
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
Answer: D
Question #12 (Topic: Topic 1)
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?
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
Answer: A
Question #13 (Topic: Topic 1)
HOTSPOT
You need to create a Microsoft Azure SQL data warehouse named dw1 that supports up to 10 TB of data.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
[Microsoft-70-776-1.0/xmlfile-26_1.jpg]
You need to create a Microsoft Azure SQL data warehouse named dw1 that supports up to 10 TB of data.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
[Microsoft-70-776-1.0/xmlfile-26_1.jpg]
Answer: [Microsoft-70-776-1.0/xmlfile-27_1.jpg]
Question #14 (Topic: Topic 1)
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?
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
Answer: B
Question #15 (Topic: Topic 1)
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?
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
Answer: B
