Pre-Summer Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

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

NOTE: Each correct selection is worth one point.

To complete the sentence, select the appropriate option in the answer area.

To complete the sentence, select the appropriate option in the answer area.

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

A.

extract transform, and load (ETL)

B.

a data warehouse

C.

online analytical processing (OLAP)

D.

online transaction processing (OLTP)

Which clause should you use in a select statement to combine rows in one tab le with rows in another table?

A.

JOIN

B.

VALUES

C.

set

D.

KEY

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

A.

an Azure SQL Database elastic pool

B.

Azure SQL Managed Instance

C.

Azure Database for MySQL

D.

Azure SQL Database

You need to analyze data by using Azure Databricks.

Which are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A.

Create a Microsoft Power Bl report.

B.

Create an Azure Data Factory pipeline.

C.

Use an Apache Spark job to process data stored in an Azure Cosmos DB database.

D.

Create a data flow in Azure Data Factory.

E.

Create an Apache Spark job that will run in a Spark cluster.

To complete the sentence, select the appropriate option in the answer area.

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

A.

Azure SQL Database Hyperscale

B.

Azure SQL managed instance

C.

Azure SQL Database serveless

D.

Azure SQL Database elastic pod

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

NOTE: Each correct selection is worth one point.