Free Practice Test

Free DP-900 Practice Test

Prepare smarter for your DP-900 exam with our free, accurate, and 2025-updated questions.

At Cert Empire, we are committed to providing the best and the latest exam questions to the aspiring students who are preparing for Microsoft DP-900 Exam. To help the students prepare better, we have made sections of our DP-900 exam preparation resources free for all. You can practice as much as you can with Free DP-900 Practice Test.

Get DP-900 Exam Dumps

Microsoft DP-900 Free Exam Questions

Disclaimer

Please keep a note that the demo questions are not frequently updated. You may as well find them in open communities around the web. However, this demo is only to depict what sort of questions you may find in our original files.

Nonetheless, the premium exam dumps files are frequently updated and are based on the latest exam syllabus and real exam questions.

1 / 60

You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?

2 / 60

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

3 / 60

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

4 / 60

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?

5 / 60

Which Azure Data Factory component initiates the execution of a pipeline?

6 / 60

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact. What should you do on the dedicated SQL pool?

7 / 60

You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario?

8 / 60

What is a characteristic of non-relational data?

9 / 60

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

10 / 60

Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends.
Which type of data store should you use?

11 / 60

Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

12 / 60

You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

13 / 60

You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?

14 / 60

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.
Which type of data store should you use?

15 / 60

You need to recommend a data store service that meets the following requirements:
✑ Native SQL API access
✑ Configurable indexes
What should you recommend?

16 / 60

You need to store data by using Azure Table storage.
What should you create first?

17 / 60

Your company is designing a data store that will contain student data. The data has the following format.

dp-900 exam demo question

 

 

 

 

 

 

 

 

 

 

Which type of data store should you use?

18 / 60

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

19 / 60

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

20 / 60

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

21 / 60

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?

22 / 60

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

23 / 60

Which storage solution supports role-based access control (RBAC) at the file and folder level?

24 / 60

Which setting can only be configured during the creation of an Azure Cosmos DB account?

25 / 60

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

26 / 60

Structured data where each row represents a single data entity uses which type of schema?

27 / 60

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

28 / 60

Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?

29 / 60

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

30 / 60

You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?

31 / 60

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?

32 / 60

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

33 / 60

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?

34 / 60

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

35 / 60

A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense.
What should the developers use?

36 / 60

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?

37 / 60

Which statement is an example of Data Definition Language (DDL)?

38 / 60

Which command-line tool can you use to query Azure SQL databases?

39 / 60

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

dp-900 exam demo question

40 / 60

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

dp-900 exam demo question

41 / 60

You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
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?

42 / 60

You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?

43 / 60

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?

44 / 60

When can you use an Azure Resource Manager template?

45 / 60

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

46 / 60

You have an inventory management database that contains the following table.

dp-900 exam demo question

 

 

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

47 / 60

Which type of database is Azure Database for PostgreSQL?

48 / 60

Which type of database contains nodes and edges?

49 / 60

You have a data store that has the structure shown in the following exhibit.

dp-900 exam demo question

 

 

 

 

 

 

 

 

 

Which type of data store is this?

50 / 60

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

51 / 60

What is a characteristic of batch processing?

52 / 60

Which storage solution supports access control lists (ACLs) at the file and folder level?

53 / 60

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

54 / 60

You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling.

Which service should you implement?

55 / 60

You need to modify a view in a relational database by adding a new column.
Which statement should you use?

56 / 60

You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?

57 / 60

You have the following data.

dp-900 exam demo question

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Which type of data is this?

58 / 60

Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.

dp-900 exam demo question

 

 

 

 

 

 

 

Which type of analysis is shown in the fourth quarter?

59 / 60

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?

60 / 60

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

Your score is

The average score is 76%

By Wordpress Quiz plugin
CertEmpire White Footer Logo - Trusted Exam Dumps Provider

CERTEMPIRE is your one-stop shop to access IT Certification Exam Dumps. We have helped thousands of people achieve their dreams of becoming certified in their desired certifications through exam dumps that surely appear in exams. We can help you achieve your goals too.

[email protected]

Helpful links

top Vendors

Contact Us

[email protected]
Copyright © 2025 Cert Empire.
Shopping Cart
Scroll to Top

FLASH OFFER

Days
Hours
Minutes
Seconds

avail $6 DISCOUNT on YOUR PURCHASE

  • USE THE CODE GIVEN BELOW ON YOUR CHECKOUT
OFFME6