Microsoft DP900 Exam Dumps|QAs Page -9

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

Q201. Which statement is an example of Data Manipulation Language (DML)?

1. GRANT
2. INSERT
3. REVOKE
4. DROP

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

1. archive storage
2. the change feed
3. soft delete
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?

1. Explore data to identify trends.
2. Implement policies, tools, and processes for backup and recovery plans.
3. Design and build analytical models.
4. Design and implement data stores for analytical workloads.

Q207. Which Azure Cosmos DB API should you use for a graph database?

1. Table
2. Cassandra
3. Core (SQL)
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.

1. a partition key
2. a range
3. a row key
4. a timestamp

Q211. What is a primary characteristic of a relational database?

1. a flexible data structure
2. data is queried and manipulated by using a variant of the SQL language
3. a lack of dependencies between tables
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?

1. an Azure Storage account
2. an Azure Key Vault
3. an Azure Information Protection policy
4. an Encryption key

Q213. In a fully normalized database, how is data read and written for a single entity?

1. Data is read from multiple tables and written to multiple tables.
2. Data is read from a single table and written to a single table.
3. Data is read from a single table and written to multiple tables.
4. Data is read from multiple tables 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?

1. full support for Transact-SQL
2. a fixed schema
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?

1. atomicity
2. durability
3. consistency
4. isolation

Q218. You need to store event log data that is semi-structured and received as the logs occur.
What should you use?

1. Azure Table storage
2. Azure Queue storage
3. Azure Files

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?

1. Table
2. Cassandra
3. NoSQL
4. 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?

1. Azure SQL Managed Instance
2. SQL Server on Azure Virtual Machines
3. Azure SQL Database
4. Azure SQL Edge

Q225. HOTSPOT-
Select the answer that correctly completes the sentence.

Correct Answer