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.

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

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

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

Match the security components to the appropriate scenarios.

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

Select the answer that correctly completes the sentence.

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

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

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

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

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?

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

NOTE: Each correct selection 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.

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.

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.

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

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.

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?

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.

You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

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.

You have the following two tables of customer data.

Which type of data do the tables contain?

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

Note: Each correct selection is worth one point.

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

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

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.