Microsoft Fundamentals DP-900 Questions & Answers

• Question 1:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

• Question 2:

  HOTSPOT

  Select the answer that correctly completes the sentence.

  Hot Area:

  

  Correct Answer:

  

• Question 3:

  HOTSPOT

  Select the answer that correctly completes the sentence.

  Hot Area:

  

  Correct Answer:

  

  SQL Server on Azure VM SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure. The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine. With this additional control comes the added responsibility to manage the virtual machine. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

• Question 4:

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

  In a fully denormalized database, how is data read and written for a single entity?

  A. Data is read from a single table and written to a single table.

  B. Data is read from multiple tables and written to a single table.

  C. Data is read from a single table and written to multiple tables.

  D. Data is read from multiple tables and written to multiple tables.

  Correct Answer: A

  Denormalization involves consolidating data into a single table to reduce the need for joins and simplify querying. This results in improved read performance as all the necessary data for a single entity can be retrieved from a single table without requiring joins with other tables. Similarly, when writing data, it is written to a single table without the need to update multiple tables. This approach is commonly used in data warehousing and reporting scenarios where read performance is prioritized over storage efficiency and data modification speed.

• Question 8:

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

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