Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 91:

  DRAG DROP

  Match the Azure Data Lake Storage Gen 2 terms to the appropriate levels in the hierarchy.

  To answer, drag the appropriate term from the column on the left to its level on the right. Each 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:

  

• Question 92:

  DRAG DROP

  Match the job roles to the appropriate tasks.

  To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 93:

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

  Hot Area:

  

  Correct Answer:

  

  A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.

  Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

• Question 94:

  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.

  Select and Place:

  

  Correct Answer:

  

  ETL https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

  Fact table https://www.techtarget.com/searchdatamanagement/definition/facttable#:~:text=A%20fact%20table%20stores%20quantitative,fact%20table%20can%20be%20analyzed.

  DW https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

• Question 95:

  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:

  

  Azure Synapse Analytics: Output data to parquet format Azure Data Lake Storage: Store data that is in parquet format Azure SQL Database: Persist a tabular representation of data that is stored in parquet format

• Question 96:

  DRAG DROP

  Match the processes to the appropriate scenarios.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 97:

  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

  The batch processing model requires a set of data that is collected over time while the stream processing model requires data to be fed into an analytics tool, often in micro-batches, and in real-time.

  The batch Processing model handles a large batch of data while the Stream processing model handles individual records or micro-batches of few records.

  In Batch Processing, it processes over all or most of the data but in Stream Processing, it processes over data on a rolling window or most recent record.

  Box 2: Batch

  Box 3: Streaming

  Reference:

  https://k21academy.com/microsoft-azure/dp-200/batch-processing-vs-stream-processing

• Question 98:

  DRAG DROP

  Match the data processing languages to the appropriate real-time analytics services.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 99:

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 100:

  DRAG DROP

  Match the Azure SQL services to the appropriate use cases.

  To answer, drag the appropriate service from the column on the left to its use case 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: