70-776

70-776 practice questions, page 3 of 4, with answer review and explanations.

Question 11

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?

  1. AdlCopy
  2. bcp
  3. FTP
  4. AzCopy

Question 12

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?

  1. resource classes
  2. resource pools
  3. MAXDOP
  4. Resource Governor

Question 13

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:

Question 14

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?

  1. Get-AzureRmSqlDatabase
  2. Get-AzureRmSqlDatabaseGeoBackup
  3. Get-AzureRmSqlDatabaseReplicationLink
  4. Get-AzureRmSqlDatabaseRestore Points

Question 15

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?

  1. the export and import of BACPAC files
  2. SQL Server Integration Services (SSIS)
  3. SQL Server backup and restore
  4. SQL Server snapshot replication