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

Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

A.

Azure Data Explorer

B.

Azure Synapse Analytics

C.

Azure Databricks

D.

Azure Stream Analytics

E.

Azure HDInsight

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

A.

Azure Functions

B.

Microsoft SQL Server Integration Services (SSIS)

C.

PolyBase

D.

Azure Data Factory

You have the following two tables of customer data.

Which type of data do the tables contain?

A.

non-relational

B.

structured

C.

semi-structured

D.

unstructured

Match the processes to the appropriate scenarios.

To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Match the database normalization terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

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

NOTE: Each correct selection is worth one point.

What is the primary purpose of a data warehouse?

A.

to provide answers to complex queries that rely on data from multiple sources

B.

to provide transformation services between source and target data stores

C.

to provide read-only storage of relational and non-relational historical data

D.

to provide storage for transactional line-of-business (LOB) applications

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

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

A.

object data

B.

graph

C.

key/value

D.

time series