Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 81:

  HOTSPOT

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Yes

  Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the

  record.

  Box 2: No

  An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.

  Box 3: Yes

  A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.

  Reference:

  https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables

  https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described

  https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15

• Question 82:

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

  Hot Area:

  

  Correct Answer:

  

  Box 1: simple lookups A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.

  An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.

  Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

• Question 83:

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

  Hot Area:

  

  Correct Answer:

  

• Question 84:

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

  Hot Area:

  

  Correct Answer:

  

• Question 85:

  HOTSPOT

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: No

  The API determines the type of account to create. Azure Cosmos DB provides five APIs: Core (SQL) and MongoDB for document data, Gremlin for graph data, Azure Table, and Cassandra. Currently, you must create a separate account for

  each API.

  Box 2: Yes

  Azure Cosmos DB uses partitioning to scale individual containers in a database to meet the performance needs of your application. In partitioning, the items in a container are divided into distinct subsets called logical partitions. Logical

  partitions are formed based on the value of a partition key that is associated with each item in a container.

  Box 3: No

  Logical partitions are formed based on the value of a partition key that is associated with each item in a container.

  Reference:

  https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview

• Question 86:

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/

• Question 87:

  DRAG DROP

  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 type on the right. Each data storage option may be used once, more than once, or not at all.

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 88:

  DRAG DROP

  Match the cloud service model to the appropriate Azure relational database service.

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 89:

  DRAG DROP

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 90:

  DRAG DROP

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

  NOTE: Each correct match is worth one point.

  Select and Place:

  

  Correct Answer: