Free Microsoft DP-900 Exam Actual Questions

The questions for DP-900 were last updated On Feb 18, 2025

At ValidExamDumps, we consistently monitor updates to the Microsoft DP-900 exam questions by Microsoft. Whenever our team identifies changes in the exam questions,exam objectives, exam focus areas or in exam requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these actual questions, our customers can successfully pass the Microsoft Azure Data Fundamentals exam on their first attempt without needing additional materials or study guides.

Other certification materials providers often include outdated or removed questions by Microsoft in their Microsoft DP-900 exam. These outdated questions lead to customers failing their Microsoft Azure Data Fundamentals exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions, guaranteeing their presence in your actual exam. Our main priority is your success in the Microsoft DP-900 exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.

 

Question No. 1

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?

Show Answer Hide Answer
Correct Answer: A

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.


https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

Question No. 2

A data engineer is responsible for which task?

Show Answer Hide Answer
Correct Answer: D

Question No. 3

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

Show Answer Hide Answer
Correct Answer: A

Question No. 4

You need to create an Azure Storage account.

Data in the account must replica outside the Azure region automatically.

Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one pint.

Show Answer Hide Answer
Correct Answer: A, C

Azure Storage offers two options for copying your data to a secondary region:

With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).


https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region

Question No. 5

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Show Answer Hide Answer