Microsoft DP-900 - Microsoft Azure Data Fundamentals

Select the answer that correctly completes the sentence.

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 the answer that correctly completes the sentence.

Match the Azure services to the appropriate locations in the architecture.

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

NOTE: Each correct match is worth one point.

Which Azure Storage service implements the key/value model?

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

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

Which three actions are used when performing diagnostic analytics?

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

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?