Last updated on October 16th, 2024 at 03:52 pm
Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.
Microsoft DP900 Exam Dumps – QAs 201-225
Table of Contents
Q201. Which statement is an example of Data Manipulation Language (DML)?
- GRANT
- INSERT
- REVOKE
- DROP
Correct Answer
2. INSERT
Q202. What should you use to automatically delete blobs from Azure Blob Storage?
- archive storage
- the change feed
- soft delete
- a lifecycle management policy
Correct Answer
4. a lifecycle management policy
Q203. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer
Q204. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer
Q205. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql
Q206. A data engineer is responsible for which task?
- Explore data to identify trends.
- Implement policies, tools, and processes for backup and recovery plans.
- Design and build analytical models.
- Design and implement data stores for analytical workloads.
Correct Answer
2. Implement policies, tools, and processes for backup and recovery plans.
Q207. Which Azure Cosmos DB API should you use for a graph database?
- Table
- Cassandra
- Core (SQL)
- Gremlin
Correct Answer
4. Gremlin
Q208. HOTSPOT-
Select the answer that correctly completes the sentence.
Correct Answer
Reference:
https://aws.amazon.com/what-is/olap/
Q209. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:
Correct Answer
Q210. In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- a partition key
- a range
- a row key
- a timestamp
Correct Answer
1. a partition key
3. a row key
Q211. What is a primary characteristic of a relational database?
- a flexible data structure
- data is queried and manipulated by using a variant of the SQL language
- a lack of dependencies between tables
- a large amount of duplicate data
Correct Answer
4. a large amount of duplicate data
Q212. You have an Azure virtual machine named VM1.
You plan to encrypt VM1 by using Azure Disk Encryption.
Which Azure resource must you create first?
- an Azure Storage account
- an Azure Key Vault
- an Azure Information Protection policy
- an Encryption key
Correct Answer
2. an Azure Key Vault
Reference:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disk-encryption-overview
Q213. In a fully normalized database, how is data read and written for a single entity?
- Data is read from multiple tables and written to multiple tables.
- Data is read from a single table and written to a single table.
- Data is read from a single table and written to multiple tables.
- Data is read from multiple tables and written to a single table.
Correct Answer
2. Data is read from a single table and written to a single table.
Q214. DRAG DROP-
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer
Q215. What is a characteristic of a non-relational database?
- full support for Transact-SQL
- a fixed schema
- self-describing entities
Correct Answer
3. self-describing entities
Q216. HOTSPOT-
Select the answer that correctly completes the sentence.
Correct Answer
Q217. A bank has a system that manages financial transactions.
When transferring money between accounts. the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?
- atomicity
- durability
- consistency
- isolation
Correct Answer
1. atomicity
Q218. You need to store event log data that is semi-structured and received as the logs occur.
What should you use?
- Azure Table storage
- Azure Queue storage
- Azure Files
Correct Answer
1. Azure Table storage
Q219. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer
Q220. HOTSPOT-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer
Q221. HOTSPOT-
Select the answer that correctly completes the sentence.
Correct Answer
Q222. Which Azure Cosmos DB API should you use for a graph database?
- Table
- Cassandra
- NoSQL
- Gremlin
Q223. HOTSPOT-
Select the answer that correctly completes the sentence.
Correct Answer
Q224. Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines
- Azure SQL Database
- Azure SQL Edge
Correct Answer
1. Azure SQL Managed Instance