Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

Select the answer that correctly completes the sentence.

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,

backups, and maintenance tasks?

A.

Azure SQL Managed Instance

B.

SQL Server on Azure Virtual Machines

C.

Azure SQL Edge

D.

Azure SQL Database

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query. What should you create?

A.

a table

B.

an index

C.

scalar function

D.

a view

What is required to provision Azure Data Lake Storage in an Azure Storage account?

A.

Versioning must be enabled.

B.

Hierarchical namespace must be enabled.

C.

Hierarchical namespace must be disabled.

D.

Versioning must be disabled.

Which service can be used to build extract, transform, and load (ETL) pipelines?

A.

Azure SQL Database

B.

Azure Pipelines

C.

Azure Databricks

D.

Azure Cosmos DB

E.

Azure Data Factory

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

A.

stream processing

B.

batch processing

C.

Online Analytical Processing (OLTP)

D.

Online Transaction Processing (OLTP)

Select the answer that correctly completes the sentence.

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL

database.

Which type of authentication should you use?

A.

service principal authentication

B.

Azure Active Directory (Azure AD) authentication

C.

SQL authentication

D.

certificate authentication

Select the answer that correctly completes the sentence.