Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 231:

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

  A. Table

  B. Cassandra

  C. Core (SQL)

  D. Gremlin

  Correct Answer: D

• Question 232:

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

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

  B. Data is read from a single table 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 a single table.

  Correct Answer: A

• Question 233:

  Which Azure Storage service implements the key/value model?

  A. Azure Queue

  B. Azure Files

  C. Azure Table

  D. Azure Blob

  Correct Answer: C

• Question 234:

  What is a function of a modern data warehouse?

  A. supports batch processing only

  B. supports real-time and batch processing

  C. provides built-in or native online analytical processing

  D. stores raw data only

  Correct Answer: B

• Question 235:

  You have an on-premises Microsoft SQL Server database.

  You need to migrate the database to the cloud. The solution must meet the following requirements:

  *

  Minimize maintenance effort.

  *

  Support the Database Mail and Service Broker features. What should you include in the solution?

  A.

  Azure SQL Database single database

  B.

  an Azure SQL Database elastic pool

  C.

  Azure SQL Managed instance

  D.

  SQL Server on Azure virtual machines

  Correct Answer: C

• Question 236:

  Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?

  A. the Hot access tier

  B. change feed

  C. snapshots

  D. versioning

  Correct Answer: B

  https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-change-feed Change feed support is well-suited for scenarios that process data based on objects that have changed. For example, applications can:

  - Update a secondary index, synchronize with a cache, search-engine, or any other content-management scenarios.

• Question 237:

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

  

  Which type of data store is this?

  A. key/value

  B. object data

  C. graph

  D. time series

  Correct Answer:

• Question 238:

  HOTSPOT

  Select the answer that correctly completes the sentence.

  Hot Area:

  

  Correct Answer:

  

• Question 239:

  HOTSPOT

  Select the answer that correctly completes the sentence.

  Hot Area:

  

  Correct Answer:

  

• Question 240:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer: