DP-900 Microsoft Certification Exam Updated Material

dumps2022-04-15T02:08:32+08:00

Microsoft certification DP-900 exam updated material is good in your preparation. We all know that DP-900 exam is a Microsoft Azure Data Fundamental test. If you are working in this industry, you can choose this Microsoft DP-900 exam to take. Free updated Microsoft DP-900 exam material is below.

Page 1 of 6

1. What are two uses of data visualization? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.

Represent trends and patterns over time.

Communicate the significance of data.

implement machine learning to predict future values.

Consistently implement business logic across reports

2. HOTSPOT

Select the answer that correctly completes the sentence.

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

4. HOTSPOT

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

5. HOTSPOT

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

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

REVOKE

DISABLE

CREATE

UPDATE

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

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

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

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

Microsoft SQL Server Management Studio (SSMS)

Azure Data Studio

Azure CLI

Azure PowerShell

Page 2 of 6

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

12. You need to recommend a data store service that meets the following requirements:

✑ Native SQL API access

✑ Configurable indexes

What should you recommend?

Azure Files

Azure Blob storage

Azure Table storage

Azure Cosmos DB

13. What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

complete control over backup and restore processes

access to the latest features

in-database machine learning services

reduced administrative effort for managing the server infrastructure

14. DRAG DROP

Match the types of activities to the appropriate Azure Data Factory activities.

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

15. HOTSPOT

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

16. HOTSPOT

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

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

18. HOTSPOT

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

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

20. Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

predictive

prescription

descriptive

diagnostic

Page 3 of 6

21. You have an application that runs on Windows and requires across to a mapped drive.

Which Azure service should you use?

Azure Cosmos DB

Azure Table storage

Azure Files

Azure Blob Storage

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

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

25. You need to gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?

Online Transaction Processing (OLTP)

batch

massively parallel processing (MPP)

streaming

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

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

28. HOTSPOT

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

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

30. HOTSPOT

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

Page 4 of 6

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

a waterfall chart

a ribbon chart

a bar chart

a decomposition tree

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

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

SELECT

INSERT

DELETE

DROP

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

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

37. HOTSPOT

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

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

Azure Cosmos D3

Azure Synapse Analytics

Azure HCMmtghi

Azure SQL Database

39. Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Azure SQL Database Hyperscale

Azure SQL managed instance

Azure SQL Database serveless

Azure SQL Database elastic pod

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

container

item

database

partition

Page 5 of 6

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

42. Which scenario is an example of a streaming workload?

sending transactions that are older than a month to an archive

sending transactions daily from point of sale (POS) devices

sending telemetry data from edge devices

sending cloud infrastructure metadata every 30 minutes

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

geo-redundancy

multi-region writes

production or non-reduction account type

API

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

45. DRAG DROP

Match the types of data stores to the appropriate scenarios.

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

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

47. You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.

What should you use?

Synapse pipelines

a Synapse SQL pool

Synapse Link

Synapse Studio

48. What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)

denormalized data

heavy writes and moderate reads

light writes and heavy reads

schema on write

schema on read

normalized data

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

control flow

linked services

datasets

the integration runtime

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

Page 6 of 6

51. HOTSPOT

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

52. HOTSPOT

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

53. Which three actions are used when performing diagnostic analytics?

• Identify data anomalies • Collect anomaly-related data • Discover relationships and trends that explain anomalies.

• Identify data anomalies • Predict when anomalies are likely to recur • Use analytical tools such as decision trees and regression.

• Apply serf-learning loops to draw inferences from anomalies. • Predict when anomalies are likely to recur • Use analytical tools such as decision trees and regression.

• Identify data anomalies • Use machine learning to find patterns in large datasets. • Discover relationships and trends that explain anomalies.

54. HOTSPOT

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

DP-900 Microsoft Certification Exam Updated Material

DP-900 Microsoft Certification Exam Updated Material

Share this post

Leave a Reply Cancel reply

Related Posts