Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 61:

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

• Question 62:

  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:

  

  Reference:

  https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15 https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

• Question 63:

  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. ELT only works well when the target system is powerful enough to transform the data efficiently. Incorrect Answers:

  1.

  The data does not need to be fully processed: Often, the three ETL phases are run in parallel to save time. For example, while data is being extracted, a transformation process could be working on data already received and prepare it for loading, and a loading process can begin working on the prepared data, rather than waiting for the entire extraction process to complete.

  2.

  The target does need to be a relational database.

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

• Question 64:

  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

• Question 65:

  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:

  

• Question 66:

  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:

  

  Box 1: No

  Microsoft handles all patching and updating of the SQL and operating system code. You don't have to manage the underlying infrastructure.

  Box 2: Yes

  SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations.

  Box 3: No

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

• Question 67:

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

  Hot Area:

  

  Correct Answer:

  

• Question 68:

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

  Hot Area:

  

  Correct Answer:

  

  Disadvantages of non-relational databases include: Data Consistency non-relational databases do not perform ACID transactions.

  Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.

  Incorrect Answers:

  Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.

  Use Cloud storage (no relational database) for geographically distributed writes.

  Reference:

  https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

• Question 69:

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

  Hot Area:

  

  Correct Answer:

  

  Paginated Reports https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/

• Question 70:

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

  Hot Area:

  

  Correct Answer: