Download 2022 Free Latest Microsoft DP-900 Practice Exam Questions

test2022-04-09T03:42:33+00:00

DP-900 Microsoft Azure Data Fundamentals is the required exam to achieve your Microsoft Certified: Azure Data Fundamentals certification,The best training tools for the DP-900 exam can be found here. DP-900 Practice Exam may not only assist you in passing the DP-900 test, but it can also help you develop your knowledge and abilities. It enables you to study for the DP-900 exam using actual exam questions and pass the first test. Before taking the DP-900 exam, you may test your knowledge with a free DP-900 practice test.

Try DP-900 free demo to test yourself!

Page 1 of 5

1. 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?

Archive

Hot

Cool

2. HOTSPOT

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

3. HOTSPOT

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

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

Azure Data Lake Storage

Azure Cosmos DB

Azure Queue storage

Azure Blob storage

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

document

columnar

graph

time series

6. DRAG DROP

Match the types of workloads to the appropriate scenarios.

To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

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

native support for cross-database queries and transactions

built-in high availability

system-Initiated automatic backups

support for encryption at rest

8. 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?

stream processing

Online Transaction Processing (OLTP)

batch processing

Online Analytical Processing (OLAP)

9. HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point.

10. You have a quality assurance application that reads data from a data warehouse.

Which type of processing does the application use?

Online Transaction Processing (OLTP)

batch processing

Online Analytical Processing (OLAP)

stream processing

Page 2 of 5

11. DRAG DROP

match the Azure data factory components to the appropriate descriptions.

To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

12. HOTSPOT

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

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

Which Azure service should you use?

Azure Files

Azure Blob storage

Azure Cosmos DB

Azure Table storage

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

Which command should you run?

az scorage share create

az scorage account creace

az cosmosdb creace

az scorage concainer creace

15. DRAG DROP

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.

Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

16. 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. (Choose two.)

the throughput

the read region

the partition key

the API

17. DRAG DROP

Match the types of data to the appropriate Azure data services.

To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

18. HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

19. You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, 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?

document

key/value

object

columnar

20. HOTSPOT

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

Page 3 of 5

21. HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

22. HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

23. DRAG DROP

Match the security components to the appropriate scenarios.

To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

24. You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query .

What should you create?

a table

an index

scalar function

a view

25. HOTSPOT

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

26. Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.

Which type of data store should you use?

Key/value

Graph

Document

columnar

27. A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers.

The developers require code assistance features such as intellSense.

What should the developers use?

Azure Data Studio

sq1cmd

Microsoft SQL Server Management Studio (SSMS)

Azure Data Explorer

28. DRAG DROP

Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.

To answer, drag the appropriate term from the column on the left to its level on the right.

Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

29. HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

30. Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

Azure HDInsight

Azure SQL Database

Azure Cosmos DB

SQL Server on Azure virtual machines

Page 4 of 5

31. HOTSPOT

You have the following SQL query.

NOTE:Each correct selection is worth one point.

32. HOTSPOT

You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point

33. HOTSPOT

For each of the following statements, select yes if he statement is true, Otherwise select No. NOTE: Each correct selection is worth one point.

34. You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

Scale down the data warehouse units (DWUs).

Pause the pool.

Create a user-defined restore point.

Delete the pool

35. HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

36. DRAG DROP

Match the datastore services to the appropriate descriptions.

To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

37. Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)

report and dashboard creation

report sharing and distribution

data modeling

data acquisition and preparation

38. HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

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

read-access geo-redundant storage (RA_GRS)

zone-redundant storage (ZRS)

geo-redundant storage (GRS)

locally-redundant storage (LRS)

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

SELECT

JOIN

MERGE

CREATE

Page 5 of 5

41. 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?

Azure Functions

Microsoft SQL Server Integration Services (SSIS)

PolyBase

Azure Data Factory

42. HOTSPOT

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