DP-900 practice questions 231–240

1. Question 231 · 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 - Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data. Box 2: Yes - Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous. Box 3: No - Reference: https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/

   Source: Adapted from community discussion — oracle_751

   References

   • Microsoft Learn

   

   Next question

2. Question 232 · 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://azure.microsoft.com/en-us/services/cognitive-services/speech-services/

   Source: Adapted from community discussion — jasu

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

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

   The same set of columns. In relational databases, a row is a data record within a table. Each row, which represents a complete record of specific item data, holds different data within the same structure. A row is occasionally referred to as a tuple. Incorrect: Not: a key value pair. Unlike relational databases, key-value databases do not have a specified structure. Relational databases store data in tables where each column has an assigned data type. Key-value databases are a collection of key-value pairs that are stored as individual records and do not have a predefined data structure. Reference: https://www.techopedia.com/definition/4425/database-row https://www.techtarget.com/searchdatamanagement/tip/NoSQL-database-types-explained-Key-value-store

   

   Next question

4. Question 234 · 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: No - Database normalization is the process of restructuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity. Full normalisation will generally not improve performance, in fact it can often make it worse but it will keep your data duplicate free. Box 2: No - Analytics systems are deformalized to increase performance. Transactional database systems are normalized to increase data consistency. Box 3: Yes - Transactional database systems are more normalized and requires more joins. Reference: https://www.sqlshack.com/what-is-database-normalization-in-sql-server

   Source: Adapted from community discussion — Kris_ETL

   

   Next question

5. Question 235 · 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

   A graph database stores two types of information, nodes and edges. Edges specify relationships between nodes. Nodes and edges can have properties that provide information about that node or edge, similar to columns in a table. Edges can also have a direction indicating the nature of the relationship. Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

   Source: Adapted from community discussion — okayhey

   References

   • Microsoft Learn

   

   Next question

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

   A key/value store associates each data value with a unique key. Key/value stores are highly optimized for applications performing simple lookups, but are less suitable if you need to query data across different key/value stores. Key/value stores are also not optimized for querying by value. A single key/value store can be extremely scalable, as the data store can easily distribute data across multiple nodes on separate machines. Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

   

   Next question

7. Question 237 · 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

   SQL Server on Azure VM - SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure. The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine. With this additional control comes the added responsibility to manage the virtual machine. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

   

   Next question

8. Question 238 · 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

   For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. Reference: https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

   

   Next question

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

   Semi-structured data - Semi-structured data (e.g., JSON, CSV, XML) is the ג€bridgeג€ between structured and unstructured data. It does not have a predefined data model and is more complex than structured data, yet easier to store than unstructured data. Reference: https://www.ibm.com/cloud/blog/structured-vs-unstructured-data

   

   Next question

10. Question 240 · 291 in bank

    Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

    • Aatomicity
    • Bisolation
    • Cdurability
    • Dconsistency

    Show answer

    Answer: A

    Explanation

    A is correct. https://www.databricks.com/glossary/acid-transactions A.C.I.D. properties: Atomicity, Consistency, Isolation, and Durability Atomicity - each statement in a transaction (to read, write, update or delete data) is treated as a single unit. Either the entire statement is executed, or none of it is executed. This property prevents data loss and corruption from occurring if, for example, if your streaming data source fails mid-stream.

    Source: Adapted from community discussion — PatYeo

    References

    • Microsoft Learn

    Next question

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

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