DP-900 practice questions 11–20

1. Question 11 · 291 in bank

   Select 2

   You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Athe throughput
   • Bthe read region
   • Cthe partition key
   • Dthe API

   Show answer

   Answer: AC

   Explanation

   Please note that the Azure Cosmos DB set-up screens have changed, making this question non-relevant. The link referenced in the answer was a screenshot taken in 2020.

   Source: Adapted from community discussion — srgopalkr

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 12 · 291 in bank

   HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Disadvantages of non-relational databases include: Data Consistency ג€" non-relational databases do not perform ACID transactions. Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility. Incorrect Answers: Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes. Use Cloud storage (no relational database) for geographically distributed writes. Reference: https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

   Source: Adapted from community discussion — man5484

   References

   • Microsoft Learn

   

   Next question

3. Question 13 · 291 in bank

   Your company is designing a data store that will contain student data. The data has the following format.

   

   Which type of data store should you use?

   • Agraph
   • Bkey/value
   • Cobject
   • Dcolumnar

   Show answer

   Answer: D

   Explanation

   Key/Value is not correct: The records habe multiple attributes, in Key/Value store you can just store one attribute. Most appropiate aswer would be Document, because attributes are not consistent in records. Since Document is not a choice, another alternative is table storage (allowing NULL values for selected columns)

   Source: Adapted from community discussion — cmohl2013

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 14 · 291 in bank

   Which storage solution supports role-based access control (RBAC) at the file and folder level?

   • AAzure Disk Storage
   • BAzure Data Lake Storage
   • CAzure Blob storage
   • DAzure Queue storage

   Show answer

   Answer: B

   Explanation

   Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs). This article summarizes the basics of the access control model for Data Lake Storage Gen2. ACLs are applied on the file and folder level. The key thing to remember is that you are always going to need RBAC Control Plane permissions in combination with ACLs. Best practice is to assign your security principals RBAC Reader role on the Storage Account/Container level and continue with more restrictive ACLs on the file and folder level. There are two types of ACLs: Access ACLs: They control access to an object. An object can be a file or a folder. Default ACLs: These are ACLs assigned on the folder level only which get inherited as Access ACLs by the child file or folder.

   Source: Adapted from community discussion — GetulioJr

   References

   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn

   Next question

5. Question 15 · 291 in bank

   You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use?

   • AArchive
   • BHot
   • CCool

   Show answer

   Answer: A

   Explanation

   Answer is correct Hot - Optimized for storing data that is accessed frequently. Cool - Optimized for storing data that is infrequently accessed and stored for at least 30 days. Archive - Optimized for storing data that is rarely accessed and stored for at least 180 days with flexible latency requirements (on the order of hours).

   Source: Adapted from community discussion — User6

   References

   • Microsoft Learn

   Next question

6. Question 16 · 291 in bank

   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?

   • Adocument
   • Bcolumnar
   • Cgraph
   • Dtime series

   Show answer

   Answer: A

   Explanation

   Very similar to Qst#110: the example there was not relational, no fix schema. etc. Despite of that "Document" was false there.

   Source: Adapted from community discussion — KMLearn3

   References

   • Microsoft Learn

   Next question

7. Question 17 · 291 in bank

   DRAG DROP - 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 the right. Each API may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/faq

   Source: Adapted from community discussion — mrjeet

   References

   • Microsoft Learn

   

   Next question

8. Question 18 · 291 in bank

   HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks. One advantage of hierarchical namespace is atomic directory manipulation: Object stores approximate a directory hierarchy by adopting a convention of embedding slashes (/) in the object name to denote path segments. Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

   Source: Adapted from community discussion — Pinha

   References

   • Microsoft Learn

   

   Next question

9. Question 19 · 291 in bank

   HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

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

   Source: Adapted from community discussion — EBAN

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 20 · 291 in bank

    When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

    • Amulti-master replication
    • BAvailability Zones
    • Cthe strong consistency level
    • Dautomatic failover

    Show answer

    Answer: B

    Explanation

    With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given REGION to provide high availability and resiliency to zonal failures. Availability Zones provide a 99.995% availability SLA with no changes to latency. In the event of a single zone failure, zone redundancy provides full data durability with RPO=0 and availability with RTO=0.

    Source: Adapted from community discussion — GetulioJr

    References

    • Microsoft Learn
    • Microsoft Learn

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-900 practice, question 11. 291 questions available.