DP-900 practice questions 191–200

1. Question 191 · 291 in bank

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

   • AData is read from a single table and written to a single table.
   • BData is read from multiple tables and written to a single table.
   • CData is read from a single table and written to multiple tables.
   • DData is read from multiple tables and written to multiple tables.

   Show answer

   Answer: A

   Explanation

   Denormalization involves consolidating data into a single table to reduce the need for joins and simplify querying. This results in improved read performance as all the necessary data for a single entity can be retrieved from a single table without requiring joins with other tables. Similarly, when writing data, it is written to a single table without the need to update multiple tables. This approach is commonly used in data warehousing and reporting scenarios where read performance is prioritized over storage efficiency and data modification speed.

   Source: Adapted from community discussion — Mega2

   Next question

2. Question 192 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   Correct, an attribute hierarchy. An attribute hierarchy allows you to organize dimension attributes into a hierarchical structure, typically with multiple levels of granularity. This enables users to easily navigate through different levels of detail within a dimension when analyzing data.

   Source: Adapted from community discussion — Mega2

   

   Next question

3. Question 193 · 291 in bank

   HOTSPOT - Select the answer that correctly completed the sentence.

   

   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

4. Question 194 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

5. Question 195 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

6. Question 196 · 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

   Descriptive, to answer the question: What's happening? Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords. You can process one media file or multiple media files in a batch. Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/ https://docs.microsoft.com/en-us/azure/media-services/previous/media-services-index-content

   Source: Adapted from community discussion — ColoradoChick

   References

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

   

   Next question

7. Question 197 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   Correct: An aggregated measure. In an analytical model, any point where dimensions intersect represents an aggregated measure. These intersections represent specific data points within the multidimensional structure, and the aggregated measures provide quantitative values based on the selected dimensions and context. Each intersection corresponds to a unique combination of dimension values, and the aggregated measure represents the result of applying aggregation functions (such as sum, average, count, etc.) to the underlying data associated with that combination of dimension values.

   Source: Adapted from community discussion — Mega2

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

8. Question 198 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   According to Chat GPT: The correct answer is: 4- Azure Synapse Analytics **Reason:** Azure Synapse Analytics is an integrated analytics service that brings together big data and data warehousing. It combines the scalability and performance of a relational data warehouse based on Microsoft SQL Server with the flexibility and capabilities of a data lake, enabling the integration and analysis of large datasets. Additionally, it incorporates Apache Spark, an open-source distributed processing system, which allows for advanced analytics and big data processing within the same service. This makes Azure Synapse Analytics a comprehensive solution for modern data warehousing and analytics needs.

   Source: Adapted from community discussion — shhy

   

   Next question

9. Question 199 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   Correct Answer Page Blobs are optimized for random read and write options. Page Blobs are ideal for scenarios that require the ability to overwrite a random small segment at a known address, like storing index-based and sparse data structures.

   Source: Adapted from community discussion — subhayu.biswas12

   

   Next question

10. Question 200 · 291 in bank

    GRANT, REVOKE, and DENY are examples of which type of SQL statement?

    • AData Definition language (DDL)
    • BData Control Language (DCL)
    • CData Manipulation Language (DML)

    Show answer

    Answer: B

    Next question

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

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