microsoft dp-900 practice test

microsoft azure data fundamentals

Last exam update: Jun 28 ,2025
Page 1 out of 28. Viewing questions 1-10 out of 279

Question 1

Which statement is an example of Data Definition Language (DDL)?

  • A. SELECT
  • B. INSERT
  • C. DELETE
  • D. DROP Most Votes
Mark Question:
Answer:

d


Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
ALTER
Collations
CREATE
DROP
DISABLE TRIGGER
ENABLE TRIGGER
RENAME
UPDATE STATISTICS
TRUNCATE TABLE
UPDATE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

User Votes:
A 6 votes
50%
B 3 votes
50%
C
50%
D 11 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
sdfds
3 months, 3 weeks ago

asfdadawedwead

0
Perrine
3 months, 1 week ago

AAAAAAAAAA

0
43006779
3 months, 1 week ago

Un. CHOISIR

0
43006779
3 months, 1 week ago

D. GOUTTE

0

Question 2

What is a characteristic of a non-relational database?

  • A. full support for Transact-SQL
  • B. a fixed schema
  • C. self-describing entities Most Votes
Mark Question:
Answer:

c

User Votes:
A 1 votes
50%
B 3 votes
50%
C 12 votes
50%
Discussions
vote your answer:
A
B
C
0 / 1000
43005288
3 months, 1 week ago

bbbbbbbbbbbbbbbbbbbbbbbbbbbbb

0
43006779
3 months, 1 week ago

C. entités auto-descriptives

0
43000957
3 months, 1 week ago

blablablalbla

0

Question 3

HOTSPOT You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Hot Area:

Mark Question:
Answer:


Box 1: star schema -
In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.
Example:

Incorrect Answers:
The data in the question is not normalized.
The snowflake schema is a variation of the star schema, featuring normalization of dimension tables. Example:

Note: A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.[citation needed]. Snowflaking is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.

Box 2: dimension -
The star schema consists of one or more fact tables referencing any number of dimension tables.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview https://en.wikipedia.org/wiki/Star_schema https://en.wikipedia.org/wiki/Snowflake_schema https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

Discussions
0 / 1000
prathyushamunjuluri
3 months, 2 weeks ago

data model is a Star schema
Customer is a dimension

0
43005288
3 months, 1 week ago

star schema
dimension

0
Perrine
3 months, 1 week ago

The data model is a star schema
Customer is a dimension table

0
emi_511
3 months, 1 week ago

data model is a star Schema ; Customer is a dimension

0
43006779
3 months, 1 week ago

The data model is a star schema.
Customer is a dimension.

0
43000957
3 months, 1 week ago

data model is a Star schema
Customer is a dimension

0

Question 4

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

  • A. Azure SQL Database
  • B. Azure Database for MySQL
  • C. Azure SQL Managed Instance Most Votes
  • D. an Azure SQL Database elastic pool
Mark Question:
Answer:

c


SQL Managed Instance has near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine, providing a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for existing SQL Server customers.
Note: Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql

User Votes:
A 3 votes
50%
B 2 votes
50%
C 10 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
Perrine
3 months, 1 week ago

CCCCCCCCCCCCCCCC

0
43005288
3 months, 1 week ago

cccccccccccc

0
emi_511
3 months, 1 week ago

CCCCCCCCCC

0
emi_511
3 months, 1 week ago

DDDDDDDDDDDDDD

0
43000957
3 months, 1 week ago

AAAAAAAAAAA

0

Question 5

HOTSPOT Select the answer that correctly completes the sentence.
Hot Area:

Mark Question:
Answer:


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

Discussions
0 / 1000
prathyushamunjuluri
3 months, 2 weeks ago

Postgre SQL server

0
emi_511
3 months, 1 week ago

Postgree SGL server

0
Perrine
3 months, 1 week ago

Virtual machine

0
43005288
3 months, 1 week ago

virtual machine

0
43006779
3 months, 1 week ago

PostgreSQL server

0
emi_511
3 months, 1 week ago

virtual machine

0
43000957
3 months, 1 week ago

virtual machine

0

Question 6

HOTSPOT To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Mark Question:
Answer:


Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal

Discussions
0 / 1000
prathyushamunjuluri
3 months, 2 weeks ago

Azure Cosmos Database

0
Perrine
3 months, 1 week ago

account

0
43000957
3 months, 1 week ago

acount ccccc

0

Question 7

Structured data where each row represents a single data entity uses which type of schema?

  • A. XML
  • B. tabular
  • C. blob
  • D. JSON
Mark Question:
Answer:

b

User Votes:
A
50%
B 8 votes
50%
C 1 votes
50%
D 1 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
emi_511
3 months, 1 week ago

tabular

0
43005288
3 months, 1 week ago

cccccccccc

0

Question 8

Which activity is most common for transactional workloads?

  • A. recording small units of work events in real time
  • B. aggregating massive amounts of data
  • C. producing complex reports
  • D. performing self-service data exploration
Mark Question:
Answer:

a

User Votes:
A 6 votes
50%
B 1 votes
50%
C 4 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
emi_511
3 months, 1 week ago

recording small units of work events in real time

0
Perrine
3 months, 1 week ago

CCCCCCCCCCCCCCCCCCCCCC

0
43005288
3 months, 1 week ago

aaaaaaaaaaa

0

Question 9

Which Azure Storage service implements the key/value model?

  • A. Azure Queue
  • B. Azure Files
  • C. Azure Table
  • D. Azure Blob
Mark Question:
Answer:

c

User Votes:
A
50%
B 2 votes
50%
C 9 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
emi_511
3 months, 1 week ago

Azure table

0
43005288
3 months, 1 week ago

ccccccccccccccc

0

Question 10

What should you use to automatically delete blobs from Azure Blob Storage?

  • A. archive storage
  • B. the change feed
  • C. soft delete
  • D. a lifecycle management policy
Mark Question:
Answer:

d

User Votes:
A 4 votes
50%
B 2 votes
50%
C
50%
D 6 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
42007471
3 months, 1 week ago

Le flux de modification

0
emi_511
3 months, 1 week ago

a lifecycle management policy

0
Perrine
3 months, 1 week ago

AAAAAAAAAAAABBBBBBBBBBBBBBBBB

0
43005288
3 months, 1 week ago

dddddddddd

0
MarNoe
2 weeks, 3 days ago

D. a lifecycle management policy

0
To page 2