DP-900 practice questions 101–110

1. Question 101 · 291 in bank

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

   Structured. Social media users and followers in a graph database is an example of structured data. Structured data is data that is organized and can be easily stored, queried, and analyzed in a specific format. Graph databases are designed to store and manage data in a structured way. They are optimized for handling data that is organized in a graph-like structure, which includes nodes (representing entities, such as social media users), and edges (representing relationships between those entities, such as followers). Unstructured data is data that does not have a specific format and can't be easily stored, queried, and analyzed. Examples of unstructured data include text, images, videos, and audio files. Semi-structured data is data that has some structure but not as defined as structured data. Examples of semi-structured data include JSON or XML files, which have a defined structure but allow for nested elements and variations in structure.

   Source: Adapted from community discussion — Stuurwiel1

   References

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

   

   Next question

2. Question 102 · 291 in bank

   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:

   

   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/what-is-database-normalization-in-sql-server/

   Source: Adapted from community discussion — yeanlingmedal71

   References

   • Microsoft Learn

   

   Next question

3. Question 103 · 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

   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

   Source: Adapted from community discussion — ati339

   References

   • Microsoft Learn

   

   Next question

4. Question 104 · 291 in bank

   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?

   • AAzure Blob storage
   • BAzure Files
   • CAzure Table storage
   • DAzure Cosmos DB

   Show answer

   Answer: D

   Explanation

   D. Azure Cosmos DB The read latency for all consistency levels is always guaranteed to be less than 10 milliseconds at the 99th percentile. The average read latency, at the 50th percentile, is typically 4 milliseconds or less. The write latency for all consistency levels is always guaranteed to be less than 10 milliseconds at the 99th percentile. The average write latency, at the 50th percentile, is usually 5 milliseconds or less. Azure Cosmos DB accounts that span several regions and are configured with strong consistency are an exception to this guarantee. https://learn.microsoft.com/en-us/azure/cosmos-db/consistency-levels

   Source: Adapted from community discussion — GilarStyle

   References

   • Microsoft Learn

   Next question

5. Question 105 · 291 in bank

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

   It was not worth paying for the contributor access for this exam. Most of the questions are pretty straight forward but the given answers are incorrect. And they don't even update them after getting feedback through the discussion.

   Source: Adapted from community discussion — gabo

   

   Next question

6. Question 106 · 291 in bank

   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:

   

   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

   YYY Yes, in a transactional database that guarantees consistency, all data changes will be logged and accounted for. This is because a transactional database follows the ACID (Atomicity, Consistency, Isolation, Durability) properties, which ensures that all transactions are executed in a reliable and consistent manner. When a transaction is executed, the database system ensures that all changes made to the data are logged in a transaction log. This log contains a record of all changes made during the transaction, including updates, inserts, and deletions. If any part of the transaction fails, the database system uses the transaction log to roll back the transaction and undo any changes that were made. By logging all data changes, the database system can ensure that the data remains consistent and that no data is lost or corrupted. In addition, the transaction log provides a history of all changes made to the data, which can be used for auditing and troubleshooting purposes.

   Source: Adapted from community discussion — tangerine141

   References

   • Microsoft Learn

   

   Next question

7. Question 107 · 291 in bank

   You have data saved in the following format.

   

   Which format was used?

   • AYAML
   • BCSV
   • CJSON
   • DHTML

   Show answer

   Answer: B

   Explanation

   CSV YAML Syntax: nearly every YAML file starts with a list. Each item in the list is a list of key/value pairs, commonly called a “hash” or a “dictionary”. So, we need to know how to write lists and dictionaries in YAML. There’s another small quirk to YAML. All YAML files (regardless of their association with Ansible or not) can optionally begin with --- and end with .... This is part of the YAML format and indicates the start and end of a document. All members of a list are lines beginning at the same indentation level starting with a "- " (a dash and a space): --- # A list of tasty fruits - Apple - Orange - Strawberry - Mango ... A dictionary is represented in a simple key: value form (the colon must be followed by a space): # An employee record martin: name: Martin D'vloper job: Developer skill: Elite

   Source: Adapted from community discussion — OldSchool

   Next question

8. Question 108 · 291 in bank

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

   

   Next question

9. Question 109 · 291 in bank

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

   it is Database administrators. Database administrators manage databases, assigning permissions to users, storing backup copies of data and restore data in the event of a failure. https://learn.microsoft.com/en-us/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles

   Source: Adapted from community discussion — ushahid

   References

   • Microsoft Learn

   

   Next question

10. Question 110 · 291 in bank

    What is required to provision Azure Data Lake Storage in an Azure Storage account?

    • AVersioning must be disabled.
    • BHierarchical namespace must be disabled.
    • CVersioning must be enabled.
    • DHierarchical namespace must be enabled.

    Show answer

    Answer: D

    Explanation

    Correct answer D: 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. https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

    Source: Adapted from community discussion — Pranava_GCP

    References

    • azure.microsoft.com documentation
    • Microsoft Learn

    Next question

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

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