DP-900 practice questions 141–150

1. Question 141 · 291 in bank

   A retail point of sale (POS) system is an example of which type of solution?

   • Aa data warehouse
   • Bonline analytical processing (OLAP)
   • Cextract, transform, and load (ETL)
   • Donline transaction processing (OLTP)

   Show answer

   Answer: D

   Explanation

   An online transaction processing (OLTP) system is designed to handle real-time transactional operations, such as capturing and processing sales transactions, inventory management, and customer interactions. POS systems are typically used in retail environments to facilitate the sale of products or services to customers.

   Source: Adapted from community discussion — fiksarion

   Next question

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

   A graph database is a collection of nodes (or vertices) and edges (or relationships). Therefore, the correct answer is Vertexes.

   Source: Adapted from community discussion — Joanna0

   

   Next question

3. Question 143 · 291 in bank

   DRAG DROP - Match the Azure Data Factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right. Each component 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: Dataset - Datasets must be created from paths in Azure datastores or public web URLs, for the data to be accessible by Azure Machine Learning. Box 2: Linked service - Linked services are much like connection strings, which define the connection information needed for Data Factory to connect to external resources. Box 3: Pipeline - A pipeline is a logical grouping of activities that together perform a task. Reference: https://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/ https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

   Source: Adapted from community discussion — Meyti

   References

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

   

   Next question

4. Question 144 · 291 in bank

   You have structured data in tabular format. What represents an individual instance of a data entity?

   • Aa column
   • Ba table
   • Ca cell
   • Da row

   Show answer

   Answer: D

   Explanation

   An entity is a thing in which information needs to be known or held. A table is the object that stores a collection of entities. A row represents a single instance of an entity. A column defines a specific property of an entity. A row !!!

   Source: Adapted from community discussion — Joanna0

   Next question

5. Question 145 · 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 146 · 291 in bank

   Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?

   • AAzure SQL Managed Instance
   • BSQL Server on Azure Virtual Machines
   • CAzure SQL Database
   • DAzure SQL Edge

   Show answer

   Answer: A

   References

   • Microsoft Learn

   Next question

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

   Relational data uses keys and relationships to enforce relationships between different tables. In a relational database, data is organized into tables, which consist of rows and columns. Each row represents a single record or entity, and each column represents a specific attribute or property of that record. Keys play a crucial role in establishing relationships between tables. A primary key is a unique identifier for each row in a table, ensuring its uniqueness and providing a way to reference that row from other tables. Foreign keys are used to create relationships between tables by linking a column in one table to the primary key column in another table.

   Source: Adapted from community discussion — fiksarion

   

   Next question

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

   Transformation engine is not needed because you will not transform the data before it is being loaded. I think the answer is "a target data store powerful enough to transform data", because there you will need power to perform a comples queries for business purposes.

   Source: Adapted from community discussion — Joanna0

   

   Next question

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

   Dimensions:- In a star schema, the entities by which you aggregate or slice measures are called dimensions. Dimensions are the descriptive attributes or perspectives of the data that provide the context for the measures (also known as facts) in the model. For example, in a sales data star schema, the dimensions could be time, product, store location, and customer. These dimensions provide context for the sales measures such as total sales, units sold, and revenue. By aggregating or slicing the measures by different dimensions, you can gain insights into the data from different perspectives.

   Source: Adapted from community discussion — coolbru

   

   Next question

10. Question 150 · 291 in bank

    DRAG DROP - Match the data storage options to the appropriate types of data. To answer, drag the appropriate data storage option from the column on the left to its data type on the right. Each data storage option may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

    

    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

    Why I think that the question is about only "data storages"? And I see only two data storages: 1. Azure Blob Storage where we can storage files and documents. 2. Azure SQL Database - where we can store tables and data. Therefore, I think that the answer should be - Azure Blob Storage, Azure Blob Storage, Azure SQL Database.

    Source: Adapted from community discussion — Joanna0

    References

    • Microsoft Learn
    • Microsoft Learn

    

    Next question

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

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