DP-900 practice questions 21–30

1. Question 21 · 291 in bank

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

   • Aprovides resiliency if an Azure region fails
   • Bsupports partitioning
   • Cprovides a higher storage capacity
   • Dsupports a multi-master model

   Show answer

   Answer: D

   Explanation

   To all of you who wonder what multi-master support actually is: 'Till now, all the distributed system architecture works like one Write data server and multiple Read data servers. Data are replicated to all data servers from Write data server. With the multi-master feature, we can choose all data servers to act as Write server data will be replicated with other data servers. The big challenge of multi-master, avoid the data duplication in data replication.' https://www.c-sharpcorner.com/article/utilize-multi-master-support-in-azure-cosmos-db/

   Source: Adapted from community discussion — [Removed]

   References

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

   Next question

2. Question 22 · 291 in bank

   Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network. Which type of data store should you use?

   • Agraph
   • Bkey/value
   • Cdocument
   • Dcolumnar

   Show answer

   Answer: A

   Next question

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

   Box 1: Yes - Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually these jobs involve reading source files from scalable storage (like HDFS, Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files in scalable storage. Box 2: No - Box 3: No - Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

   Source: Adapted from community discussion — Armandoo

   References

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

   

   Next question

4. Question 24 · 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

   Box 1: Yes - Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector. The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs. Box 2: Yes - You can stream data into Azure Databricks using Event Hubs. Box 3: Yes - You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector. Cosmos can be used for batch and stream processing, and as a serving layer for low latency access. You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure. Reference: https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs

   

   Next question

5. Question 25 · 291 in bank

   DRAG DROP - Match the datastore services to the appropriate descriptions. To answer, drag the appropriate service from the column on the left to its description on the right. Each service 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

   Box 1: Azure Cosmos DB - In Azure Cosmos DB's SQL (Core) API, items are stored as JSON. The type system and expressions are restricted to deal only with JSON types. Box 2: Azure Files - Azure Files offers native cloud file sharing services based on the SMB protocol. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json https://cloud.netapp.com/blog/azure-smb-server-message-block-in-the-cloud-for-azure-files

   References

   • Microsoft Learn

   

   Next question

6. Question 26 · 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://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal

   

   Next question

7. Question 27 · 291 in bank

   You need to store data by using Azure Table storage. What should you create first?

   • Aan Azure Cosmos DB instance
   • Ba storage account
   • Ca blob container
   • Da table

   Show answer

   Answer: B

   Next question

8. Question 28 · 291 in bank

   You need to recommend a data store service that meets the following requirements: ✑ Native SQL API access ✑ Configurable indexes What should you recommend?

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

   Show answer

   Answer: D

   Explanation

   Maybe, the question is obsolete? Looks like Cosmos DB automatically creates indexes on all properties and provides NO index management. Check Indexing section: https://docs.microsoft.com/en-us/azure/cosmos-db/table/table-support

   Source: Adapted from community discussion — GAFE

   References

   • Microsoft Learn

   Next question

9. Question 29 · 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

   Box 1: Yes - For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone- redundant storage (RA-GZRS). Box 2: No - Box 3: Yes - Box 4: Yes - Azure Cosmos DB supports multi-region writes. Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy https://manojchoudhari.wordpress.com/2019/12/16/azure-cosmos-db-enable-multi-region-writes

   Source: Adapted from community discussion — Mjwc

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 30 · 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. Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

    Source: Adapted from community discussion — LarsLarsgren

    

    Next question

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

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