microsoft dp-900 practice test

microsoft azure data fundamentals

Last exam update: Apr 12 ,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
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 5 votes
50%
B 2 votes
50%
C
50%
D 6 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
sdfds
1 month, 1 week ago

asfdadawedwead

0
Perrine
3 weeks, 2 days ago

AAAAAAAAAA

0
43006779
3 weeks, 2 days ago

Un. CHOISIR

0
43006779
3 weeks, 2 days 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
Mark Question:
Answer:

c

User Votes:
A 1 votes
50%
B 3 votes
50%
C 6 votes
50%
Discussions
vote your answer:
A
B
C
0 / 1000
43005288
3 weeks, 2 days ago

bbbbbbbbbbbbbbbbbbbbbbbbbbbbb

0
43006779
3 weeks, 2 days ago

C. entités auto-descriptives

0
43000957
3 weeks, 2 days 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
1 month ago

data model is a Star schema
Customer is a dimension

0
43005288
3 weeks, 2 days ago

star schema
dimension

0
Perrine
3 weeks, 2 days ago

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

0
emi_511
3 weeks, 2 days ago

data model is a star Schema ; Customer is a dimension

0
43006779
3 weeks, 2 days ago

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

0
43000957
3 weeks, 2 days 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
  • 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 2 votes
50%
B 1 votes
50%
C 6 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
Perrine
3 weeks, 2 days ago

CCCCCCCCCCCCCCCC

0
43005288
3 weeks, 2 days ago

cccccccccccc

0
emi_511
3 weeks, 2 days ago

CCCCCCCCCC

0
emi_511
3 weeks, 2 days ago

DDDDDDDDDDDDDD

0
43000957
3 weeks, 2 days 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
1 month ago

Postgre SQL server

0
emi_511
3 weeks, 2 days ago

Postgree SGL server

0
Perrine
3 weeks, 2 days ago

Virtual machine

0
43005288
3 weeks, 2 days ago

virtual machine

0
43006779
3 weeks, 2 days ago

PostgreSQL server

0
emi_511
3 weeks, 2 days ago

virtual machine

0
43000957
3 weeks, 2 days 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
1 month ago

Azure Cosmos Database

0
Perrine
3 weeks, 2 days ago

account

0
43000957
3 weeks, 2 days 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 4 votes
50%
C 1 votes
50%
D 1 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
emi_511
3 weeks, 2 days ago

tabular

0
43005288
3 weeks, 2 days 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 2 votes
50%
B
50%
C 4 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
emi_511
3 weeks, 2 days ago

recording small units of work events in real time

0
Perrine
3 weeks, 2 days ago

CCCCCCCCCCCCCCCCCCCCCC

0
43005288
3 weeks, 2 days 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 1 votes
50%
C 5 votes
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
emi_511
3 weeks, 2 days ago

Azure table

0
43005288
3 weeks, 2 days 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 2 votes
50%
B 2 votes
50%
C
50%
D 2 votes
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
42007471
3 weeks, 2 days ago

Le flux de modification

0
emi_511
3 weeks, 2 days ago

a lifecycle management policy

0
Perrine
3 weeks, 2 days ago

AAAAAAAAAAAABBBBBBBBBBBBBBBBB

0
43005288
3 weeks, 2 days ago

dddddddddd

0
To page 2