Recommend!!

Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

Microsoft
Exam Questions DP-900
Microsoft Azure Data Fundamentals

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

A. report and dashboard creation

B. report sharing and distribution
C. data modeling
D. data acquisition and preparation

Answer: AD

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 10
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?

A. service principal authentication

B. Azure Active Directory (Azure AD) authentication
C. SQL authentication
D. certificate authentication

Answer: B

NEW QUESTION 10
To complete the sentence select the appropriate option in the answer area.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 14
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. (Choose two.)
NOTE: Each correct selection is worth one point.

A. the throughput
B. the read region
C. the partition key
D. the API

Answer: AC

NEW QUESTION 17
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

A. native support for cross-database queries and transactions

B. built-in high availability
C. system-Initiated automatic backups
D. support for encryption at rest

Answer: A

NEW QUESTION 22

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 26
Which scenario is an example of a streaming workload?

A. sending transactions that are older than a month to an archive

B. sending transactions daily from point of sale (POS) devices
C. sending telemetry data from edge devices
D. sending cloud infrastructure metadata every 30 minutes

Answer: C

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

A. multi-master replication
B. Availability Zones
C. automatic failover
D. the strong consistency level

Answer: B

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

NEW QUESTION 36
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.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 38
You have a transactional application that stem data in an Azure SQ1 managed instance. When should you implement a read-only database replica?

A. You need to generate reports without affecting the transactional workload.

B. You need to audit the transactional application.
C. You need to implement high availability in the event of a regional outage
D. You need to improve the recovery point objective (RPO).

Answer: C

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 46
When can you use an Azure Resource Manager template?

A. to automate the creation of an interdependent group of Azure resources in a repeatable way

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

B. to automate the creation of an interdependent and develop can deploy from the Azure portal
C. To provision Azure subscriptions and apply policies for multi-tenant deployments
D. To set complex permissions automatically on existing objects in an Azure subscription

Answer: C

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

A. SELECT
B. JOIN
C. MERGE
D. CREATE

Answer: D

NEW QUESTION 52
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

A. Online Transaction Processing (OLTP)

B. batch processing
C. Online Analytical Processing (OLAP)
D. stream processing

Answer: A

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 67
For each of the following statements, select yes if the statement is true, Otherwise, select No. Note: Each correct selection is worth one point.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 68
Which Azure Data Factory component provides the compute environment for activities?

A. a linked service
B. an integration runtime
C. a control flow
D. a pipeline

Answer: A

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

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 75
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?

A. document
B. columnar
C. graph
D. time series

Answer: A

NEW QUESTION 80
You have the following SQL query.

NOTE: Each correct selection is worth one point.

A. Mastered
B. Not Mastered

Answer: A

Explanation:

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

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

A. a control flow
B. a trigger
C. a parameter
D. an activity

Answer: B

NEW QUESTION 86
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?

A. Azure DNS
B. Azure Application Gateway
C. Azure Private link
D. Azure Traffic Manager

Answer: B

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 92
What should you use to build a Microsoft Power BI paginated report?

A. Power BI report Builder

B. Power BI Desktop
C. Charticulator
D. the Power BI service

Answer: B

NEW QUESTION 97
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?

A. Archive
B. Hot
C. Cool

Answer: A

NEW QUESTION 102

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

A. stream processing
B. batch processing
C. Online Analytical Processing (OLTP)

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

D. Online Transaction Processing (OLTP)

Answer: D

NEW QUESTION 105

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 110

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?

A. document
B. key/value
C. object
D. columnar

Answer: C

NEW QUESTION 115

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

A. relational
B. columnar
C. graph
D. time series

Answer: A

NEW QUESTION 118

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.

A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box

Answer: ACE

NEW QUESTION 123

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

Match the Azure services to the appropriate locations in the architecture.

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 124

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?

A. queue
B. blob
C. file
D. table

Answer: B

NEW QUESTION 126

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

A. the Azure Active director/ (Azure AO) account that created the database
B. the Azure Active Directly Azure AD) administrator account
C. the sa account
D. the server admin login account of the logical server

Answer: B

NEW QUESTION 131

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

A. Mastered
B. Not Mastered

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

Answer: A

Explanation:

NEW QUESTION 133

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

Which type of data store should you use?

A. graph
B. key/value
C. object
D. columnar

Answer: D

NEW QUESTION 138

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 142

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

A. a database-level firewall
B. role-based access control (RSAC)
C. Dynamic Host Configuration Protocol (DHCP)
D. Domain Name Service (DNS)

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

Answer: D

NEW QUESTION 145

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.

A. read-access geo-redundant storage (RA_GRS)

B. zone-redundant storage (ZRS)
C. geo-redundant storage (GRS)
D. locally-redundant storage (LRS)

Answer: AC

NEW QUESTION 150

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 151

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

A. Mastered
B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 155

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?

A. Azure Cosmos D3

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

B. Azure Synapse Analytics

C. Azure HCMmtghi
D. Azure SQL Database

Answer: B

NEW QUESTION 159

......

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

 Recommend!! Get the Full DP-900 dumps in VCE and PDF From SurePassExam
https://www.surepassexam.com/DP-900-exam-dumps.html (122 New Questions)

Thank You for Trying Our Product

We offer two products:

1st - We have Practice Tests Software with Actual Exam Questions

2nd - Questons and Answers in PDF Format

DP-900 Practice Exam Features:

* DP-900 Questions and Answers Updated Frequently

* DP-900 Practice Questions Verified by Expert Senior Certified Staff

* DP-900 Most Realistic Questions that Guarantee you a Pass on Your FirstTry

* DP-900 Practice Test Questions in Multiple Choice Formats and Updatesfor 1 Year

100% Actual & Verified — Instant Download, Please Click

Order The DP-900 Practice Test Here

Passing Certification Exams Made Easy visit - https://www.surepassexam.com

Powered by TCPDF (www.tcpdf.org)