Free Microsoft DP-900 Practice Exam with Questions & Answers | Set: 8

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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?

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.

Which file format has defined names and data types for each column and uses compressed columnar storage?

Select the answer that correctly completes the sentence.