Secret To Pass 70-776 Exam With Valid Microsoft 70-776 Exam Questions [April 2018 Dumps]


Pdfdumps provides you valid and real 70-776 exam pdf dumps and 70-776 practice test software. You need to make sure that you are in a best position to pass the Perform Big Data Engineering on Microsoft Cloud Services (beta) 70-776 exam when you appear in 70-776 exam. Hence you need latest 70-776 exam dumps if you want to pass 70-776 exam in first attempt. Try demo of 70-776 exam pdf before purchase.

♥ 2018 VALID 70-776 Exam Questions ♥

Free Download NEW 70-776 Exam Dumps (PDF and Practice test software):
Available on:

Latest Microsoft 70-776 Dumps Exam Questions and Answers:

Version: 9.0
Question: 51

You have a Microsoft Azure SQL data warehouse. You have an Azure Data Lake Store that contains data from ORC, RC, Parquet, and delimited text files.
You need to load the data to the 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.
A. Use Microsoft SQL Server Integration Services (SSIS) to enumerate from the Data Lake Store by using a for loop.
B. Use AzCopy to export the files from the Data Lake Store to Azure Blob storage.
C. For each file in the loop, export the data to Parallel Data Warehouse by using a Microsoft SQL Server Native Client destination.
D. Load the data by executing the CREATE TABLE AS SELECT statement.
E. Use bcp to import the files.
F. In the data warehouse, configure external tables and external file formats that correspond to the Data Lake Store.
Answer: D,F   
Question: 52

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 
Question: 53

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 
Question: 54

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 
Question: 55

You have a Microsoft Azure Data Lake Store and an Azure Active Directory tenant.
You are developing an application that will access the Data Lake Store by using end-user credentials.
You need to ensure that the application uses end-user authentication to access the Data Lake Store.
What should you create?
A. a Native Active Directory app registration
B. a policy assignment that uses the Allowed resource types policy definition
C. a Web app/API Active Directory app registration
D. a policy assignment that uses the Allowed locations policy definition
Answer: A