DP-900 Microsoft Azure Data Fundamentals Questions and Answers

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

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.

correctly completes the sentence.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Which Azure Cosmos DB API stores data in the BSON format and uses MQL to query the data?

At which level in Azure Cosmos DB can you configure multiple write regions and read regions?

You need to create an Azure resource to store data in Azure Table storage.

Which command should you run?

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 used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

For each of the following statements, select yes if he statement is true, Otherwise select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

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.

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

What is the primary purpose of a data warehouse?

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

You need to create an Azure Storage account.

Data in the account must replica outside the Azure region automatically.

Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one pint.

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

Select the answer that correctly completes the sentence.

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

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Your company is designing a database that will contain session data for a website. The data will include

notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

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

Select the answer that correctly completes the sentence.

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

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

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

Select the answer that correctly completes the sentence.

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

Which three actions are used when performing diagnostic analytics?

Select the answer that correctly completes the sentence.

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

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.

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

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.

What should the developers use ?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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

A data engineer is responsible for which task?

What is a primary characteristic of a relational database?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

What is a characteristic of batch processing?

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.

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

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL

database.

Which type of authentication should you use?

Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

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

Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

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

You have data in a tabular format as shown in the following table.

Of which type of data is this an example?

Select the answer that correctly completes the sentence.

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

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 used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

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

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

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Which type of Azure resource supports the serverless configuration of an Azure SQL database?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Which Azure Data Factory component initiates the execution of a pipeline?

Select the answer that correctly completes the sentence.

You plan to deploy a PostgreSQL database to Azure.

Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

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 the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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

For each of the following statements, select yes if the statement is true, Otherwise, select No.

Note: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Match the types of data to the appropriate Azure data services.

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

NOTE: Each correct match is worth one point.

What is a characteristic of non-relational data?

You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.

What should you use in Microsoft Power BI?

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.

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

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.

What is the responsibility of a database administrator?

You need to gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Which type of database is Azure Database for PostgreSQL?

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

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