DP-900 Exam Questions

You have a data store that has the structure shown in the following exhibit. Which type of data store is this?

Which type of database contains nodes and edges?

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

Drag and Drop Question 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...

A data engineer is responsible for which task?

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

A retail point of sale (POS) system is an example of which type of solution?

You have structured data in tabular format. What represents an individual instance of a data entity?

Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?

Drag and Drop Question Match the data storage options to the appropriate types of data. To answer, drag the appropriate data storage option from the column on the left to its data...

Drag and Drop Question Match the data processing languages to the appropriate real-time analytics services. To answer, drag the appropriate term from the column on the left to its...

What is a difference between structured data and semi-structured data?

A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes tempo...

Which statement is an example of Data Manipulation Language (DML)?

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

Which Azure Cosmos DB API should you use for a graph database?

A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either...

Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

Which activity is most common for transactional workloads?

You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

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

Drag and Drop Question 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 t...

Drag and Drop Question Match the cloud service model to the appropriate Azure relational database service. To answer, drag the appropriate cloud service model from the column on th...

Drag and Drop Question Match the job roles to the appropriate tasks. To answer, drag the appropriate job role from the column on the left to its task on the right. Each role may be...

Drag and Drop Question 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 use...

Drag and Drop Question 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 use...

How is raw data stored in a data lakehouse?

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

Which three services support Apache Spark? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have data in a tabular format as shown in the following table. Of which type of data is this an example?

What can you use to create data ingestion pipelines?

Which service is optimized for IoT scenarios that involve streaming time series data?

Which statement is an example of Data Definition Language (DDL)?

What is the responsibility of a database administrator?

You have the following T-SQL statement. SELECT o.OrderNo, o.OrderDate, c.Address, c.City FROM Order AS o JOIN Customer AS c ON o.Customer = c.ID; What is the function of the ON cla...

You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer. Which two Transact-SOL...

You have a database that stores data in the format shown in the following table. Of which type of database is this an example?

You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling. Which service should you i...

You need to accept and store large quantities of IoT streaming data. Which database solution should you use?

Which type of Microsoft Power BI visual can you use to examine trends over time for one or more series of values?

Which service can be used to build extract, transform, and load (ETL) pipelines?