Advance Your Career by Using Online DP-900 Dumps

Category:

Comments:

0 Comments

Post Date:

March 16, 2023

Obtaining the Microsoft Azure certification DP-900 certification can help you demonstrate your expertise in Microsoft solutions and advance your career in related industry. Using DP-900 dumps as part of your study plan can help you identify knowledge gaps, improve your exam-taking skills, provide immediate feedback, and increase your chances of passing the DP-900 exam. Microsoft DP-900 exam free dumps questions are available below.

Page 1 of 9

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

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

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

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

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

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

8. HOTSPOT

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

9. HOTSPOT

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

10. HOTSPOT

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

Page 2 of 9

11. Select the answer that correctly completes the sentence.

12. HOTSPOT

Select the answer that correctly completes the sentence.

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

Match the Azure Cosmos DB APIs to the appropriate data structures.

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

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

16. You need to store event log data that is semi-structured and received as the logs occur.

What should you use?

Azure Table storage

Azure Queue storage

Azure Files

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

18. HOTSPOT

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

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

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

Page 3 of 9

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

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

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. Which type of database is Azure Database for PostgreSQL?

Platform as a service (PaaS)

Infrastructure as a service (laaS)

Microsoft SQL Server

on-premises

25. You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

extract transform, and load (ETL)

a data warehouse

online analytical processing (OLAP)

online transaction processing (OLTP)

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

Azure Synapse Analytics

Azure HDInsight

Azure SQL Database

27. Select the answer that correctly completes the sentence.

28. HOTSPOT

Select the answer that correctly completes the sentence.

29. HOTSPOT

Select the answer that correctly completes the sentence.

30. HOTSPOT

Select the answer that correctly completes the sentence.

Page 4 of 9

31. HOTSPOT

You have the following JSON document.

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

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 Azure Data Factory component provides the compute environment for activities?

a linked service

an integration runtime

a control flow

a pipeline

34. Select the answer that correctly completes the sentence.

35. HOTSPOT

Select the answer that correctly completes the sentence.

36. Select the answer that correctly completes the sentence.

37. Select the answer that correctly completes the sentence.

38. 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 seriesthe relationship

39. HOTSPOT

Select the answer that correctly completes the sentence.

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

Page 5 of 9

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

Select the answer that correctly completes the sentence.

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

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

45. Select the answer that correctly completes the sentence.

46. HOTSPOT

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

47. HOTSPOT

Select the answer that correctly completes the sentence.

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

49. HOTSPOT

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

50. 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 6 of 9

51. HOTSPOT

Select the answer that correctly completes the sentence.

52. DRAG DROP

Match the terms to the appropriate descriptions.

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

53. HOTSPOT

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

54. You have data saved in the following format:

Which format was used?

YAML

HTML

XML

JSON

55. What is a difference between structured data and semi-structured data?

Structured data has a fixed schema and semi-structured data has a flexible schema.

Only Structured data supports entities.

Structured data has a flexible schema and semi-structured data has a fixed schema.

Only Structured data supports attributes.

56. HOTSPOT

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

57. Select the answer that correctly completes the sentence.

58. SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Data Definition Language (DDL)

Data Control Language (DCL)

Data Manipulation Language (DML)

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

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

Page 7 of 9

61. Select the answer that correctly completes the sentence.

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

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

64. HOTSPOT

Select the answer that correctly completes the sentence.

65. Select the answer that correctly completes the sentence.

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

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

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

69. HOTSPOT

Select the answer that correctly completes the sentence.

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

Page 8 of 9

71. Select the answer that correctly completes the sentence.

72. HOTSPOT

Select the answer that correctly completes the sentence.

73. HOTSPOT

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

74. HOTSPOT

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

75. HOTSPOT

Select the answer that correctly completes the sentence.

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

77. HOTSPOT

Select the answer that correctly completes the sentence.

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

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

80. You have a SQL query that combines customer data and order dat a. 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?

a scalar function

a table

an index

a view

Page 9 of 9

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

82. You have a transactional application that stem data in an Azure SQL managed instance.

When should you implement a read-only database replica?

You need to generate reports without affecting the transactional workload.

You need to audit the transactional application.

You need to implement high availability in the event of a regional outage

You need to improve the recovery point objective (RPO).

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

soft delete

archive storage

the change feed

a lifecycle management policy

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

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

a fixed schema

self-describing entities

full support for Transact-SQL

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

consistency

durability

isolation

atomicity

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

TAGS:

DP-900, DP-900 exam dumps

Notify of

Label

Name*

Email*

Website

Label

Name*

Email*

Website

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Get DP-900 Dumps Full Version

Q&As: 306
Versions: PDF and Software Download Now

About Dumpsinfo

Dumpsinfo is a good platform providing the latest exam information and dumps questions for all IT certification exams. You can study all the latest exam dumps questions online.

[email protected]

Mon - Sat 9:00am - 6:00pm

Advance Your Career by Using Online DP-900 Dumps

Related

Posts

MB-260 Exam Dumps – Reliable Way to Pass and Get Certified

2024 Microsoft MB-220 Exam Dumps Questions

Good MB-820 Exam Dumps Save Your Preparation Time

Prepare DP-600 Exam with Using DP-600 Dump Questions

About Us

EMAIL

Services

Opening Hours