You have a Microsoft Azure SQL data warehouse. The following statements are used to define file formats in
the data warehouse.
You have an external PolyBase table named file_factPowerMeasurement that uses the FileFormat_ORC file
format.
You need to change file_ factPowerMeasurement to use the FileFormat_PARQUET file format.
Which two statements should you execute? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A.
CREATE EXTERNAL TABLE
B.
ALTER TABLE
C.
CREATE EXTERNAL TABLE AS SELECT
D.
ALTER EXTERNAL DATA SOURCE
E.
DROP EXTERNAL TABLE
New 70-776 Exam Questions Updated Recently (27/Dec/2017):
NEW QUESTION 1
You have an extract, transformation, and load (ETL) process for a Microsoft Azure SQL data warehouse. You run the following statements to create the logon and user for an account that will run the nightly data load for the data warehouse:
CREATE LOGIN LoaderLogin WITH PASSWORD = ‘mypassword’;
CREATE USER LoaderUser for LOGIN LoaderLogin;
You connect to the data warehouse. You need to ensure that the user can access the highest resource class. Which statement should you execute?
A. ALTER SERVER ROLE xLargeRC ADD MEMBER LoaderLogin;
B. EXEC sp_addrolemember ‘xlargerc’, ‘LoaderUser’
C. ALTER SERVER ROLE LargeRC ADD MEMBER LoaderUser;
D. EXEC sp_addrolemember ‘largerc’, ‘LoaderLogin’
Answer: B
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!
BTW, part of that new 75Q 70-776 dumps are available here:
https://drive.google.com/open?id=1R1iVzArLOI8VIIsY-pYYTq5ktJzHBkJR
Best Regards!
Hi,
Can you also please share the files for all 75 questions for 70-775 exam.
Best Regards.