DP-900 Online Practice Questions and Answers

You have the following JSON document.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document. NOTE: Each correct selection is worth one point.

Hot Area:

HOTSPOT

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

Hot Area:

HOTSPOT

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

NOTE: Each correct selection is worth one point.

Hot Area:

HOTSPOT

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

NOTE: Each correct selection is worth one point.

Hot Area:

HOTSPOT

Select the answer that correctly completes the sentence.

Hot Area:

Match the types of workloads the appropriate scenario.

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

NOTE: Each correct match is worth one point.

Select and Place:

DRAG DROP

Match the types of data stores to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

Select and Place:

DRAG DROP Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar

between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Select and Place:

DRAG DROP

Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select and Place:

You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you use?

A. Azure Cosmos DB

B. Azure Table storage

C. Azure Files

D. Azure Blob Storage

Which command-line tool can you use to query Azure SQL databases?

A. sqlcmd

B. bcp

C. azdata

D. Azure CLI

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.

What should you use?

A. Microsoft SQL Server Data Tools (SSDT)

B. Microsoft SQL Server Management Studio (SSMS)

C. Azure Databricks

D. Azure Data Studio

Which Azure Data Factory component initiates the execution of a pipeline?

A. a control flow

B. a trigger

C. a parameter

D. an activity

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 need to modify a view in a relational database by adding a new column.

Which of following statement should you use?

A. MERGE

B. ALTER

C. INSERT

D. UPDATE