Limited-Time Offer: Enjoy 50% Savings! - Ends In 0d 00h 00m 00s Coupon code: 50OFF
Welcome to QA4Exam
Logo

- Trusted Worldwide Questions & Answers

Most Recent Microsoft DP-900 Exam Dumps

 

Prepare for the Microsoft Azure Data Fundamentals exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Microsoft DP-900 exam and achieve success.

The questions for DP-900 were last updated on May 3, 2025.
  • Viewing page 1 out of 61 pages.
  • Viewing questions 1-5 out of 306 questions
Get All 306 Questions & Answers
Question No. 1

When can you use an Azure Resource Manager template?

Show Answer Hide Answer
Correct Answer: A

You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed

To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.


https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview

Question No. 2

You need to store data by using Azure Table storage.

What should you create first?

Show Answer Hide Answer
Correct Answer: B

First create an Azure storage account, then use Table service in the Azure portal to create a table.

Note: An Azure storage account contains all of your Azure Storage data objects: blobs, files, queues, and tables.


https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-quickstart-portal

https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create

Question No. 3

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?

Show Answer Hide Answer
Correct Answer: D

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.


https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Question No. 4

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. 5

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Show Answer Hide Answer
Correct Answer: D

Unlock All Questions for Microsoft DP-900 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 306 Questions & Answers