Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 21:

  HOTSPOT

  Select the answer that correctly completes the sentence.

  Hot Area:

  

  Correct Answer:

  

  A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.

  Reference: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15

• Question 22:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15

• Question 23:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

• Question 24:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  In the ELT pipeline, the transformation occurs in the target data store. Instead of using a separate transformation engine, the processing capabilities of the target data store are used to transform data.

  Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

• Question 25:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15

• Question 26:

  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:

  

  Correct Answer:

  

  Yes - Stream processing has access to the most recent data received or data within a rolling time window. Stream processing operates on data in near real-time, allowing for analysis and processing of data as it is received or within a defined time window.

  No - Batch processing is not required to occur immediately and can have higher latency. Batch processing typically operates on larger volumes of data and is often performed at regular intervals or in scheduled batches, which can have latency in the order of minutes, hours, or even days.

  Yes - Stream processing is commonly used for simple response functions, aggregates, or calculations such as rolling averages. It enables real-time data analysis and enables quick calculations and aggregations on streaming data as it arrives.

• Question 27:

  HOTSPOT

  You plan to deploy a PostgreSQL database to Azure.

  Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://azure.microsoft.com/en-us/overview/what-is-saas/ https://azure.microsoft.com/en-us/overview/what-is-paas/

• Question 28:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

• Question 29:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

• Question 30:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15