Which attribute can you detect by using the function?

(27/Dec/2017 Updated) New 70-776 Exam Questions:

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. Get The Newest 70-776 Dumps In PDF And VCE From — https://www.passleader.com/70-776.html (75q VCE and PDF)

Good Luck!