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 Azure Import/Export service
B.
SQL Server log shipping
C.
Azure Data Factory
D.
the AzCopy utility
New 70-776 Exam Questions and Answers Updated Recently (27/Dec/2017):
NEW QUESTION 1
You have an on-premises Microsoft SQL Server instance. You plan to copy a table from the instance to a Microsoft Azure Storage account. You need to ensure that you can copy the table by using Azure Data Factory. Which service should you deploy?
A. An on-premises Data Gateway
B. Azure Application Gateway
C. Data Management Gateway
D. A Virtual Network Gateway
Answer: C
NEW QUESTION 2
You have an on-premises deployment of Active Directory named contoso.com. You plan to deploy a Microsoft Azure SQL data warehouse. You need to ensure that the data warehouse can be accessed by contoso.com users. Which two components should you deploy? (Each correct answer presents part of the solution. Choose two.)
A. Azure AD Privileged Identity Management
B. Azure Information Protection
C. Azure Active Directory
D. Azure AD Connect
E. Cloud App Discovery
F. Azure Active Directory B2C
Answer: CD
NEW QUESTION 3
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 4
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
NEW QUESTION 5
You plan to add a file from Microsoft Azure Data Lake Store to Azure Data Catalog. You run the Data Catalog tool and select Data Lake Store as the data source. Which information should you enter in the Store Account field to connect to the Data Lake Store?
A. an email alias
B. a server name
C. a URL
D. a subscription ID
Answer: C
NEW QUESTION 6
You have a Microsoft Azure SQL data warehouse named DW1 that is used only from Monday to Friday. You need to minimize Data Warehouse Unit (DWU) usage during the weekend. What should you do?
A. From the Azure CLI, run the account set command.
B. Run the ALTER DATABASE statement.
C. Call the Create or Update Database REST API.
D. Run the Suspend-AzureRmSqlDatabase Azure PowerShell cmdlet.
Answer: D
NEW QUESTION 7
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
NEW QUESTION 8
You are designing a solution that will use Apache HBase on Microsoft Azure HDInsight. You need to design the row keys for the database to ensure that client traffic is directed over all of the nodes in the cluster. What are two possible techniques that you can use? (Each correct answer presents a complete solution. Choose two.)
A. padding
B. trimming
C. hashing
D. salting
Answer: AC
NEW QUESTION 9
You have a Microsoft Azure SQL data warehouse that has 10 compute nodes. You need to export 10 TB of data from a data warehouse table to several new flat files in Azure Blob storage. The solution must maximize the use of the available compute nodes. What should you do?
A. Use the bcp utility.
B. Execute the CREATE EXTERNAL TABLE AS SELECT statement.
C. Create a Microsoft SQL Server Integration Services (SSIS) package that has a data flow task.
D. Create a Microsoft SQL Server Integration Services (SSIS) package that has an SSIS Azure Blob Storage task.
Answer: D
NEW QUESTION 10
You have a Microsoft Azure subscription that contains an Azure Data Factory pipeline. You have an RSS feed that is published on a public website. You need to configure the RSS feed as a data source for the pipeline. Which type of linked service should you use?
A. Web
B. OData
C. Azure Search
D. Azure Data Lake Store
Answer: A
NEW QUESTION 11
……
P.S. These New 70-776 Exam Questions Were Just Updated From The Real 70-776 Exam, You Can Get The Newest 70-776 Dumps In PDF And VCE From — https://www.passleader.com/70-776.html (75q VCE and PDF)
Good Luck!
Besides, part of the new 75Q 70-776 dumps are available here:
https://drive.google.com/open?id=1R1iVzArLOI8VIIsY-pYYTq5ktJzHBkJR
Best Regards!