Microsoft DP-900 Dumps - Shortcut Key To Success

Microsoft DP-900 Dumps – Shortcut Key To Success

Jonnie Karnath2023-05-09T10:49:07+00:00

If you’re looking for a shortcut key to your success in the DP-900 Microsoft Azure Data Fundamentals exam, Certspots provides up-to-date, accurate, and reliable Microsoft DP-900 dumps that have been carefully crafted to help you pass your exam on the first try. These Microsoft DP-900 dumps have been designed to cover all the topics and concepts that you’ll need to know to pass the Microsoft DP-900 exam. Plus, they’re updated regularly to ensure that they reflect any changes or updates to the exam. They’re available in different formats, including PDF and practice exam software, which allows you to practice and test your knowledge before the actual exam.

Page 1 of 8

1. HOTSPOT

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

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

queue

blob

file

table

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

isolation

durability

consistency

atomicity

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

5. DRAG DROP

Match the Azure services to appropriate requirements.

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

6. CORRECT TEXT

Select the answer that correctly completes the sentence.

7. You have data saved in the following format:

Which format was used?

YAML

HTML

XML

JSON

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

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. What is required to provision Azure Data Lake Storage in an Azure Storage account?

Versioning must be enabled.

Hierarchical namespace must be enabled.

Hierarchical namespace must be disabled.

Versioning must be disabled.

Page 2 of 8

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

12. HOTSPOT

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

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

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

15. What is a characteristic of a non-relational database?

a fixed schema

self-describ ing entities

full support for Transact-SQL

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

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

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

Page 3 of 8

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

Select the answer that correctly completes the sentence.

23. What can be used with native notebook support to query and visualize data by using a web-based interface?

Azure Databricks

pgAdmin

Microsoft Power Bl

24. Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

consistency

durability

isolation

atomicity

25. HOTSPOT

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

26. CORRECT TEXT

Select the answer that correctly completes the sentence.

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

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

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

Page 4 of 8

31. HOTSPOT

Select the answer that correctly completes the sentence.

32. HOTSPOT

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

33. At which level in Azure Cosmos DB can you configure multiple write regions and read regions?

database

partition

collection

account

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

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. Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents acomplete solution. NOTE: Each correct selection is worth one point.(Choose three.)

a report page

a Microsoft PowerPoint slide

a visualization from a report

a dataflow

a text box

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

38. You need to design and model a database by using a graphical tool that supports project-oriented offlinedatabase development.

What should you use?

Microsoft SQL Server Data Tools (SSDT)

Microsoft SQL Server Management Studio (SSMS)

Azure Databricks

Azure Data Studio

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

service principal authentication

Azure Active Directory (Azure AD) authentication

SQL authentication

certificate authentication

40. What is the primary purpose of a data warehouse?

to provide answers to complex queries that rely on data from multiple sources

to provide transformation services between source and target data stores

to provide read-only storage of relational and non-relational historical data

to provide storage for transactional line-of-business (LOB) applications

Page 5 of 8

41. When provisioning an Azure Cosmos DB account, which feature provides redundancy

within an Azure region?

multi-master replication

Availability Zones

automatic failover

the strong consistency level

42. DRAG DROP

Match the Azure SQL services to the appropriate use cases.

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

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

44. DRAG DROP

Match the types of analytics that can be used to answer the business questions.

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

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

46. What should you use to automatically delete blobs from Azure Blob Storage?

soft delete

archive storage

the change feed

a lifecycle management policy

47. Which type of Azure resource supports the serverless configuration of an Azure SQL database?

Azure SQL Managed Instance

SQL Server on Azure Virtual Machines

a single database in Azure SQL Database

an Azure SQL Database elastic pool

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

49. Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.

What should you use?

Azure DNS

Azure Application Gateway

Azure Private link

Azure Traffic Manager

50. HOTSPOT

Select the answer that correctly completes the sentence.

Page 6 of 8

51. You have structured data in tabular format.

What represents an individual instance of a data entity?

a column

a cell

a row

a table

52. CORRECT TEXT

Select the answer that correctly completes the sentence.

53. HOTSPOT

Select the answer that correctly completes the sentence.

54. What should you use to build a Microsoft Power BI paginated report?

Power BI report Builder

Power BI Desktop

Charticulator

the Power BI service

55. HOTSPOT

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

56. HOTSPOT

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

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

58. HOTSPOT

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

59. DRAG DROP

Match the types of workloads the appropriate scenario.

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.

60. HOTSPOT

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

Page 7 of 8

61. HOTSPOT

Select the answer that correctly completes the sentence.

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

63. HOTSPOT

Select the answer that correctly completes the sentence.

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

65. DRAG DROP

You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.

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

67. HOTSPOT

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

68. HOTSPOT

Select the answer that correctly completes the sentence.

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

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

Azure Time Series Insights

Azure HDInsight

Azure Databricks

Azure Log Analytics

Page 8 of 8

71. HOTSPOT

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

72. HOTSPOT

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

73. HOTSPOT

Select the answer that correctly completes the sentence.

74. CORRECT TEXT

Select the answer that correctly completes the sentence.

75. HOTSPOT

Select the answer that correctly completes the sentence.

76. HOTSPOT

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

77. DRAG DROP

Match the types of analytics that can be used to answer the business questions.

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

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

79. HOTSPOT

Select the answer that correctly completes the sentence.

Facebook Twitter LinkedIn Google + Email