DP-900 practice questions 91–100

1. Question 91 · 291 in bank

   What is a function of a modern data warehouse?

   • Asupports batch processing only
   • Bsupports real-time and batch processing
   • Cprovides built-in or native online analytical processing
   • Dstores raw data only

   Show answer

   Answer: B

   Explanation

   Personal preferrence goes to B. Key phrase is 'modern' data warehouse. From Microsoft learn: Large-scale data warehousing solutions combine conventional data warehousing used to support business intelligence (BI) with techniques used for so-called "big data" analytics. A conventional data warehousing solution typically involves copying data from transactional data stores into a relational database with a schema that's optimized for querying and building multidimensional models. Big Data processing solutions on the other hand, are used with large volumes of data in multiple formats, which is batch loaded or captured in real-time streams and stored in a data lake from which distributed processing engines like Apache Spark are used to process it. Answer C is functional of conventional data warehouse. Reference https://learn.microsoft.com/bs-latn-ba/training/modules/examine-components-of-modern-data-warehouse/1-introduction

   Source: Adapted from community discussion — OrangeSG

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 92 · 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

   I ask chatGPT what option should azure storage account have enabled to support azure data lake storage ? 1. Hierarchical namesapce 2. versionning --> answer chatGPT : To support Azure Data Lake Storage, an Azure Storage account must have the hierarchical namespace feature enabled. The hierarchical namespace feature allows for a directory and file structure within the Azure Storage account, which is necessary for organizing and managing data in Azure Data Lake Storage.

   Source: Adapted from community discussion — Ahmadov_10

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

3. Question 93 · 291 in bank

   What can be used with native notebook support to query and visualize data by using a web-based interface?

   • AAzure Databricks
   • BpgAdmin
   • CMicrosoft Power BI

   Show answer

   Answer: A

   Explanation

   Notebooks are a common tool in data science and machine learning for developing code and presenting results. In Azure Databricks, notebooks are the primary tool for creating data science and machine learning workflows and collaborating with colleagues. Databricks notebooks provide real-time coauthoring in multiple languages, automatic versioning, and built-in data visualizations. Reference Introduction to Databricks notebooks https://learn.microsoft.com/en-us/azure/databricks/notebooks/

   Source: Adapted from community discussion — OrangeSG

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 94 · 291 in bank

   You have data saved in the following format.

   

   Which format was used?

   • AXML
   • BHTML
   • CYAML
   • DJSON

   Show answer

   Answer: D

   Explanation

   JSON data is written as name/value pairs (aka key/value pairs), A name/value pair consists of a field name (in double quotes), followed by a colon, followed by a value:Example as "name":"John"

   Source: Adapted from community discussion — Pranava_GCP

   Next question

5. Question 95 · 291 in bank

   You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?

   • Aan index
   • Ba view
   • Ca scalar function
   • Da table

   Show answer

   Answer: B

   Explanation

   A. Incorrect. An index is used to improve the speed of data retrieval and does not store a query or combine tables. B. Correct. A view is a virtual table based on a SQL query that combines data from multiple tables and can include calculated columns. Other users can rerun the query by simply querying the view, making it an ideal choice for reusing a specific query. C. Incorrect. A scalar function returns a single value based on input parameters, not a result set of combined data from multiple tables. D. Incorrect. A table stores data but does not directly store a query. Creating a table would require duplicating data rather than reusing a specific query.

   Source: Adapted from community discussion — man5484

   Next question

6. Question 96 · 291 in bank

   You have data saved in the following format.

   

   Which format was used?

   • AJSON
   • BYAML
   • CHTML
   • DXML

   Show answer

   Answer: D

   Explanation

   D XML is correct. The syntax is clearly XML, not YAML. See https://en.wikipedia.org/wiki/YAML#Example XML start with tagging <> and end with to be easy to see.

   Source: Adapted from community discussion — pallmall

   Next question

7. Question 97 · 291 in bank

   Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

   • Aconsistency
   • Batomicity
   • Cdurability
   • Disolation

   Show answer

   Answer: C

   Explanation

   C is correct, Durability – when a transaction has been committed, it will remain committed and saved to hard disk, after system reboot or restart, the data will be loaded back from hard disk so no data loss occurred.

   Source: Adapted from community discussion — Pranava_GCP

   References

   • Microsoft Learn

   Next question

8. Question 98 · 291 in bank

   Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

   • Aatomicity
   • Bdurability
   • Cisolation
   • Dconsistency

   Show answer

   Answer: A

   Explanation

   Atomicity is the right answer. An atomic transaction is an indivisible and irreducible series of database operations such that either all occurs, or nothing occurs. A guarantee of atomicity prevents updates to the database occurring only partially, which can cause greater problems than rejecting the whole series outright. As a consequence, the transaction cannot be observed to be in progress by another database client.

   Source: Adapted from community discussion — thewrongbeckie

   References

   • Microsoft Learn

   Next question

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

   References

   • Microsoft Learn

   

   Next question

10. Question 100 · 291 in bank

    Which Azure Storage service implements the key/value model?

    • AAzure Queue
    • BAzure Files
    • CAzure Table
    • DAzure Blob

    Show answer

    Answer: C

    Explanation

    C - https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-overview Azure Table storage is a service that stores non-relational structured data (also known as structured NoSQL data) in the cloud, providing a key/attribute store with a schemaless design.

    Source: Adapted from community discussion — nalwd

    References

    • Microsoft Learn
    • azure.microsoft.com documentation

    Next question

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

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