Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 101:

  DRAG DROP

  Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Box 1: Batch

  Batch processing refers to the processing of blocks of data that have already been stored over a period of time.

  Box 2: Streaming

  Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as

  they get generated and get instant analytics results.

  Box 3: Batch

• Question 102:

  DRAG DROP 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 and Place:

  

  Correct Answer:

  

  Box 1: The CRM system

  Data is extracted from the CRM system.

  Box 2: The data warehouse

  Data is loaded to the data warehouse.

  Box 3: A standalone data analysis tool

  The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.

  

• Question 103:

  DRAG DROP

  Match the Azure services to the appropriate requirements.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Box 1: Azure Data Factory

  Box 2: Azure Data Lake Storage

  Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the native extractor and outputter for the popular Parquet file format

  Box 3: Azure Synapse Analytics

  Use Azure Synapse Analytics Workspaces.

  Reference:

  https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs

• Question 104:

  DRAG DROP

  Match the datastore services to the appropriate descriptions.

  To answer, drag the appropriate service from the column on the left to its description on the right.

  Each service may be used once, more than once, or not at all.

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Box 1: Azure Cosmos DB

  In Azure Cosmos DB's SQL (Core) API, items are stored as JSON. The type system and expressions are restricted to deal only with JSON types.

  Box 2: Azure Files

  Azure Files offers native cloud file sharing services based on the SMB protocol.

  Reference:

  https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json

  https://cloud.netapp.com/blog/azure-smb-server-message-block-in-the-cloud-for-azure-fil

• Question 105:

  DRAG DROP

  Match the types of analytics that can be used to answer the business questions.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Box 1: Diagnostic

  Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of

  gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.

  Box 2: Prescriptive

  Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.

  Incorrect Answer:

  Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome

  Box 3: Cognitive

  Reference:

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

  https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

• Question 106:

  DRAG DROP

  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.

  Select and Place:

  

  Correct Answer:

  

  Box Ingest: Azure Data Factory

  You can build a data ingestion pipeline with Azure Data Factory (ADF).

  Box Preprocess and model: Azure Synapse Analytics

  Use Azure Synapse Analytics to preprocess data and deploy machine learning models.

  Reference: https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/sqldw-walkthrough

• Question 107:

  DRAG DROP

  Match the types of visualizations to the appropriate descriptions.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Box 1: Tree map

  Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.

  

  Box 2: Key influencer

  A key influencer chart displays the major contributors to a selected result or value.

  Box 3: Scatter

  Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.

• Question 108:

  DRAG DROP

  Match the types of data stores to the appropriate scenarios.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

• Question 109:

  DRAG DROP

  Match the Azure Cosmos DB APIs to the appropriate data structures.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/faq

• Question 110:

  DRAG DROP

  Match the terms to the appropriate descriptions.

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

  NOTE: Each correct match is worth one point.ach term may be used once, more than once, or not at all.

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

  Reference:

  https://en.wikipedia.org/wiki/Table_(database)#:~:text=A%20table%20is%20a%20collection,table%20format%20within%20a%20database.andtext=In%20relational%20databases%2C%20and%20flat,a%20row%20and%20column%20intersect.

  https://en.wikipedia.org/wiki/View_(SQL)

  https://en.wikipedia.org/wiki/Database_index#:~:text=A%20database%20index%20is%20a,maintain%20the%20index%20data%20structure.