Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Microsoft
Microsoft Certified: Azure Data Fundamentals
DP-900
Microsoft Azure Data Fundamentals Questions and Answers

Pass the Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam DP-900 Premium Access

View all detail and faqs for the DP-900 exam

Go to Exam

830 Students Passed

91% Average Score

91% Same Questions

Viewing page 3 out of 10 pages

Viewing questions 21-30 out of questions

Questions # 21:

Select the answer that correctly completes the sentence.

Question # 21

Options:

Answer

Answer:

Questions # 22:

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

Options:

MERGE

ALTER

INSERT

UPDATE

Answer

Questions # 23:

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options:

complete control over backup and restore processes

access to the latest features

in-database machine learning services

reduced administrative effort for managing the server infrastructure

Answer

B, C

Explanation

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview, , ]

Questions # 24:

Select the answer that correctly completes the sentence.

Question # 24

Options:

Answer

Answer:

Questions # 25:

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

Options:

Azure Table storage

Azure Queue storage

Azure Files

Answer

Questions # 26:

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

Options:

supports partitioning

provides resiliency if art Azure region fads

provides a higher storage capacity

supports a multi-master model

Answer

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, ]

Questions # 27:

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Options:

WHERE

SELECT

JOIN

Answer

Questions # 28:

To complete the sentence, select the appropriate option in the answer area.

Question # 28

Options:

Answer

Answer:

Explanation

[Reference:, https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/, , , ]

Questions # 29:

Select the answer that correctly completes the sentence.

Options:

Answer

Answer:

See the answer below:

Explanation

Answer as below.

Questions # 30:

You have an application that runs on Windows and requires access to a mapped drive.

Which Azure service should you use?

Options:

Azure Files

Azure Blob storage

Azure Cosmos DB

Azure Table storage

Answer

Explanation

Azure Files is Microsoft's easy-to-use cloud file system. Azure file shares can be seamlessly used in Windows and Windows Server.

To use an Azure file share with Windows, you must either mount it, which means assigning it a drive letter or mount point path, or access it via its UNC path.

[Reference:, https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows, , , , ]

Viewing page 3 out of 10 pages

Viewing questions 21-30 out of questions