Microsoft Fundamentals DP-900 Questions & Answers

• Question 1:

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

  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:

  

• Question 3:

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

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

  Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

  A. an Azure SQL Database elastic pool

  B. Azure SQL Managed Instance

  C. Azure Database for MySQL

  D. Azure SQL Database

  Correct Answer: B

• Question 6:

  Which language is used to define queries in Azure Synapse Data Explorer?

  A. Bash

  B. PowerShell

  C. KQL

  D. SQL

  Correct Answer: C

• Question 7:

  Which file format has defined names and data types for each column and uses compressed columnar storage?

  A. JSON

  B. CSV

  C. Apache Parquet

  D. HTML

  Correct Answer: C

• Question 8:

  What can be used with native notebook support to query and visualize data by using a web-based interface?

  A. Azure Databricks

  B. pgAdmin

  C. Microsoft Power Bl

  Correct Answer: A

• Question 9:

  In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

  A. a timestamp

  B. a range

  C. a row key

  D. a partition key

  Correct Answer: CD

• Question 10:

  You have the following two tables of customer data.

  

  Which type of data do the tables contain?

  A. non-relational

  B. structured

  C. semi-structured

  D. unstructured

  Correct Answer: D