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 Apr 22, 2026.

Viewing page 1 out of 61 pages.
Viewing questions 1-5 out of 306 questions

Get All 306 Questions & Answers

Question No. 1

When you create an Azure SQL database, which account can always connect to the database ?

Athe Azure Active director/ (Azure AO) account that created the database

Bthe Azure Active Directly Azure AD) administrator account

Cthe sa account

Dthe server admin login account of the logical server

Show Answer

Correct Answer: D

When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.

https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Question No. 2

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

Aa waterfall chart

Ba ribbon chart

Ca bar chart

Da decomposition tree

Show Answer

Correct Answer: A

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Question No. 3

Which scenario is an example of a streaming workload?

Asending transactions that are older than a month to an archive

Bsending transactions daily from point of sale (POS) devices

Csending telemetry data from edge devices

Dsending cloud infrastructure metadata every 30 minutes

Show Answer

Correct Answer: C

Question No. 4

You need to create an Azure resource to store data in Azure Table storage.

Which command should you run?

Aaz scorage share create

Baz scorage account creace

Caz cosmosdb creace

Daz scorage concainer creace

Show Answer

Correct Answer: D

https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest

Question No. 5

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

AAzure Functions

BMicrosoft SQL Server Integration Services (SSIS)

CPolyBase

DAzure Data Factory

Show Answer

Correct Answer: C

https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html

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