Microsoft DP-900 Real Exam Questions
The questions for DP-900 were last updated at Jul 24,2024.
- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Jul 24,2024
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal
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. NOTE: Each correct selection is worth one point. (Choose three.)
- A . You must be assigned the Reader role for the resource group that contains the database.
- B . You must have SELECT access to the Products table.
- C . You must have a user in the database.
- D . You must be assigned the Contributor role for the resource group that contains the database.
- E . Your IP address must be allowed to connect to the database.
BCE
Explanation:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15
You have an Azure SQL database that you access directly from the internet.
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure
What is a possible cause of the issue?
- A . a database-level firewall
- B . role-based access control (RSAC)
- C . Dynamic Host Configuration Protocol (DHCP)
- D . Domain Name Service (DNS)
A
Explanation:
The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.
When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.
Reference: https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/
DRAG DROP
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
- A . supports partitioning
- B . provides resiliency if art Azure region fads
- C . provides a higher storage capacity
- D . supports a multi-master model
D
Explanation:
Multi-master support for Azure Cosmos DB is now available in all public regions.
Azure CosmosDB table API is a key-value storage hosted in the cloud. It’s a part of Azure Cosmos DB, that is Microsoft’s multi-model database.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/table-support
You have a SQL query that combines customer data and order dat a. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?
- A . a table
- B . an index
- C . scalar function
- D . a view
D
Explanation:
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?
- A . Azure Cosmos DB
- B . Azure Synapse Analytics
- C . Azure HDInsight
- D . Azure SQL Database
D
Explanation:
Azure SQL Database is relational database and a managed service.
Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?
- A . Key/value
- B . Graph
- C . Document
- D . columnar
B
Explanation:
Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.
A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB’s Gremlin API supports the property graph model.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15