DP-900 practice questions 1–10

1. Question 1 · 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://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

   Source: Adapted from community discussion — SamuelSami

   References

   • Microsoft Learn

   

   Next question

2. Question 2 · 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/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15

   Source: Adapted from community discussion — yeanlingmedal71

   

   Next question

3. Question 3 · 291 in bank

   Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

   • ASELECT
   • BWHERE
   • CJOIN

   Show answer

   Answer: B

   Explanation

   Not a trick question, just how much you understand database. Select * From Countries where CountryName = "USA" This is a full table scan because CountryName is not a key, the engine need to compare every row. Select * From Countries where CountryID = 33 This is not a full table scan, it become a index scan because CountryID is a key so the engine know it can skip to that ID Select * From Countries This is a full table scan but with no criteria, so it extract everything out

   Source: Adapted from community discussion — stella_mah

   References

   • Microsoft Learn

   Next question

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

   Azure Synapse Analytics is an platform as a service (PAAS) that combines data integration, warehousing, and analytics into one solution. Azure Synapse Analytics offers cloud-based, relational data warehousing services, massively parallel processing (MPP) scale-out technology, and enough computational power to efficiently manage petabytes and petabytes of data. Incorrect: * Azure Database for MariaDB is a relational database service based on the open-source MariaDB Server engine. It's a fully managed database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. * Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business. Reference: https://cswsolutions.com/blog/posts/2021/august/what-is-azure-synapse-analytics/ https://www.integrate.io/blog/what-is-azure-synapse-analytics/

   References

   • Microsoft Learn

   

   Next question

5. Question 5 · 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 clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column.A Reference: https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server

   Source: Adapted from community discussion — raydel92

   References

   • Microsoft Learn

   

   Next question

6. Question 6 · 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 primary key is a special relational database table column (or combination of columns) designated to uniquely identify each table record (row). Reference: https://www.techopedia.com/definition/5547/primary-key

   

   Next question

7. Question 7 · 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 database view is a subset of a database and is based on a query that runs on one or more database tables. Reference: https://www.ibm.com/docs/SSWT9A_7.6.0/com.ibm.mbs.doc/configur/c_views.html

   

   Next question

8. Question 8 · 291 in bank

   Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

   • AAzure SQL Database
   • BAzure Database for MySQL
   • CAzure SQL Managed Instance
   • Dan Azure SQL Database elastic pool

   Show answer

   Answer: C

   References

   • Microsoft Learn

   Next question

9. Question 9 · 291 in bank

   Which setting can only be configured during the creation of an Azure Cosmos DB account?

   • Ageo-redundancy
   • Bmulti-region writes
   • Cproduction or non-production account type
   • DAPI

   Show answer

   Answer: D

   Explanation

   You must choose the API so you can't switch this within the creation process. Got this description from the creation page: Create Azure Cosmos DB Account - Core (SQL) Global Distribution "Configure global distribution and regional settings for your account. You can also change these settings after the account is created."

   Source: Adapted from community discussion — Bambi0074

   References

   • Microsoft Learn

   Next question

10. Question 10 · 291 in bank

    DRAG DROP - Match the types of data stores to the appropriate scenarios. To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type 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: Key/value - A key/value store associates each data value with a unique key. Box 2: Object - Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Box 3: Graph - 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

    

    Next question

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

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