Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 51:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

• Question 52:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/

• Question 53:

  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://www.sqlshack.com/what-is-database-normalization-in-sql-server/

• Question 54:

  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 55:

  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/azure/databricks/scenarios/what-is-azure-databricks https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview https://docs.microsoft.com/en-us/azure/data-factory/introduction

• Question 56:

  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/azure/azure-sql/database/sql-database-paas-overview

  https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/

• Question 57:

  You are reviewing the data model shown in the following exhibit.

  

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

  Hot Area:

  

  Correct Answer:

  

  Box 1: star schema

  In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any

  number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.

  Example:

  

  Incorrect Answers:

  The data in the question is not normalized.

  The snowflake schema is a variation of the star schema, featuring normalization of dimension tables. Example:

  

  Note: A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are

  connected to multiple dimensions.[citation needed]. "Snowflaking" is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a

  snowflake with the fact table in the middle.

  Box 2: dimension

  The star schema consists of one or more fact tables referencing any number of dimension tables.

  Reference:

  https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview https://en.wikipedia.org/wiki/Star_schema https://en.wikipedia.org/wiki/Snowflake_schema https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

• Question 58:

  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:

  

  Correct Answer:

  

  Reference: https://www.w3schools.com/js/js_json_arrays.asp https://www.w3schools.com/js/js_json_objects.asp

• Question 59:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console

• Question 60:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/