DP-900 Exam QUESTIONS with Correct
Verified Solutions
You need to query a table named Products in an Azure SQL database. Which three
requirements must be met to query the table from the internet?
Each correct answer presents part of the solution. (Choose three.)
You must be assigned the Reader role for the resource group that contains the database.
You must have SELECT access to the Products table.
You must have a user in the database.
You must be assigned the Contributor role for the resource group that contains the
database.
Your IP address must be allowed to connect to the database.
Your IP address must be allowed to connect to the database.
You must have SELECT access to the Products table.
You must have a user in the database.
Azure Blob Storage supports what three types of blobs?
Block blobs
Page blobs
Append blobs
Blob storage provides what three access tiers?
,The Hot tier
The Cool tier
The Archive tier
Name the Blob storage access tier.
The ____ tier is the default. You use this tier for blobs that are accessed frequently. The
blob data is stored on high-performance media.
Hot
Name the Blob storage access tier.
The ______ tier has lower performance and incurs reduced storage charges compared to
the Hot tier. Use the ______ tier for data that is accessed infrequently.
Cool
Name the Blob storage access tier.
The __________ tier provides the lowest storage cost, but with increased latency. The
____________tier is intended for historical data that mustn't be lost, but is required only
rarely. Blobs in the ______________tier are effectively stored in an offline state.
Archive
,___________________ is essentially a way to create cloud-based network shares, such as
you typically find in on-premises organizations to make documents and other files available
to multiple users.
Azure Files
Azure Files supports what two common network file sharing protocols?
Server Message Block (SMB)
Network File System (NFS)
____________________ is a NoSQL storage solution that makes use of tables containing
key/value data items. Each item is represented by a row that contains columns for the data
fields that need to be stored.
Azure Table Storage
What are the elements of an Azure Table storage key?
- Table name and column name
- Partition key and row key
- Row number
Partition key and row key
What should you do to an existing Azure Storage account in order to support a data lake
for Azure Synapse Analytics?
- Add an Azure Files share
- Create Azure Storage tables for the data you want to analyze
- Upgrade the account to enable hierarchical namespace and create a blob container
, Upgrade the account to enable hierarchical namespace and create a blob container
Why might you use Azure File storage?
- To share files that are stored on-premises with users located at other sites.
- To enable users at different sites to share files.
- To store large binary data files containing images or other unstructured data.
To enable users at different sites to share files.
Match the Cosmos DB API with the correct data storage format.
1. Core (SQL) API
2. Mongo DB API
3. Table API
4. Cassandra API
5. Gremlin API
A. Key-Value
B. Column-family
C. Graph
D. BSON
E. JSON
Core (SQL) API - JSON
Mongo DB API - BSON
Table API - Key-Value
Verified Solutions
You need to query a table named Products in an Azure SQL database. Which three
requirements must be met to query the table from the internet?
Each correct answer presents part of the solution. (Choose three.)
You must be assigned the Reader role for the resource group that contains the database.
You must have SELECT access to the Products table.
You must have a user in the database.
You must be assigned the Contributor role for the resource group that contains the
database.
Your IP address must be allowed to connect to the database.
Your IP address must be allowed to connect to the database.
You must have SELECT access to the Products table.
You must have a user in the database.
Azure Blob Storage supports what three types of blobs?
Block blobs
Page blobs
Append blobs
Blob storage provides what three access tiers?
,The Hot tier
The Cool tier
The Archive tier
Name the Blob storage access tier.
The ____ tier is the default. You use this tier for blobs that are accessed frequently. The
blob data is stored on high-performance media.
Hot
Name the Blob storage access tier.
The ______ tier has lower performance and incurs reduced storage charges compared to
the Hot tier. Use the ______ tier for data that is accessed infrequently.
Cool
Name the Blob storage access tier.
The __________ tier provides the lowest storage cost, but with increased latency. The
____________tier is intended for historical data that mustn't be lost, but is required only
rarely. Blobs in the ______________tier are effectively stored in an offline state.
Archive
,___________________ is essentially a way to create cloud-based network shares, such as
you typically find in on-premises organizations to make documents and other files available
to multiple users.
Azure Files
Azure Files supports what two common network file sharing protocols?
Server Message Block (SMB)
Network File System (NFS)
____________________ is a NoSQL storage solution that makes use of tables containing
key/value data items. Each item is represented by a row that contains columns for the data
fields that need to be stored.
Azure Table Storage
What are the elements of an Azure Table storage key?
- Table name and column name
- Partition key and row key
- Row number
Partition key and row key
What should you do to an existing Azure Storage account in order to support a data lake
for Azure Synapse Analytics?
- Add an Azure Files share
- Create Azure Storage tables for the data you want to analyze
- Upgrade the account to enable hierarchical namespace and create a blob container
, Upgrade the account to enable hierarchical namespace and create a blob container
Why might you use Azure File storage?
- To share files that are stored on-premises with users located at other sites.
- To enable users at different sites to share files.
- To store large binary data files containing images or other unstructured data.
To enable users at different sites to share files.
Match the Cosmos DB API with the correct data storage format.
1. Core (SQL) API
2. Mongo DB API
3. Table API
4. Cassandra API
5. Gremlin API
A. Key-Value
B. Column-family
C. Graph
D. BSON
E. JSON
Core (SQL) API - JSON
Mongo DB API - BSON
Table API - Key-Value
