Pass Microsoft DP-900 Exam – My Story And Study Resources

What are the recommended study materials for passing the Microsoft DP-900 exam? And how long have you been studying? Is it difficult? These are the questions that many people want to ask. Come on, here’s how I passed the Microsoft Azure Data Fundamentals exam – DP-900 exam dumps. I hope I can inspire you and help you get past it.

First,
Get the latest updated Microsoft DP-900 exam dumps https://www.pass4itsure.com/dp-900.html (Pass4itSure, You can trust).

Secondly,
Exam practice.
Yes! Just do two things.

Not only by means but also by sharing free Microsoft DP-900 learning resources! (This site shares part of the Microsoft DP-900 exam practice questions)

You can search for the latest updated Microsoft exam practice questions at microsoft-technet.com

DP-900 Azure Data Fundamentals exam PDF free sharing

The free Microsoft DP-900 exam PDF: https://drive.google.com/file/d/13XjgOv2o_mQOnOXP1-2sMOsWRfbU6kHS/view?usp=sharing

Microsoft Fundamentals DP-900 exam questions online practice

QUESTION 1

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

Correct Answer: AC

Reference: https://www.sqlshack.com/start-your-journey-with-azure-cosmos-db/

QUESTION 2

Match the types of workloads in 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.
Select and Place:

Correct Answer:

QUESTION 3

To complete the sentence select the appropriate option in the answer area.
Hot Area:

Correct Answer:

QUESTION 4

You have a SQL query that combines customer data and order data
The query includes calculated columns.
You need to persist in the SQL query so that other users can use the query. What should you create?

A. a table
B. an index
C. scalar function
D. a view

Correct Answer: B

QUESTION 5

You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you
use?

A. Azure Cosmos DB
B. Azure Table storage
C. Azure Files
D. Azure Blob Storage

Correct Answer: A

QUESTION 6

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

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views

QUESTION 7

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

Box 1: Azure Data factory
Relevant Azure service for the three ETL phases is Azure Data Factory and SQL Server Integration Services (SSIS).

Box 2: Azure Synapse Analytics You can copy and transform data in Azure Synapse Analytics by using Azure Data
Factory

Note: Azure Synapse Analytics connector is supported for the following activities: Copy activity with supported
source/sink matrix table Mapping data flow Lookup activity GetMetadata activity

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse

QUESTION 8

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

A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema on write
E. schema on reading
F. normalized data

Correct Answer: BDE

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

QUESTION 9

HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct Answer:

QUESTION 10

Your company is designing a database that will contain session data for a website. The data will include
notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will
provide the lowest latency to retrieve the data?

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

Correct Answer: C

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores

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

Reference: https://www.sqlshack.com/what-is-database-normalization-in-sql-server/

QUESTION 12

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

A. INSERT
B. DISABLE
C. ALTER
D. DROP

Correct Answer: A

Data Manipulation Language (DML) statements: DELETE INSERT UPDATE

Reference: https://docs.microsoft.com/enus/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements

QUESTION 13

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 use 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)

Correct Answer: AC

Azure Storage offers two options for copying your data to a secondary region:

Geo-redundant storage (GRS)
Geo-zone-redundant storage (GZRS)
With GRS or GZRS, the data in the secondary region isn\’t available for reading or write access unless there is a failover
to the secondary region.

For read access to the secondary region, configure your storage account to use read-access geo-redundant storage
(RA-GRS) or read-access geo-zone- redundant storage (RA-GZRS).

Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a- secondary-region

QUESTION 14

HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Reference: https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/

QUESTION 15

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.
Hot Area:

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/

The exercises are only part of the complete dump. Okay, just share here.

It’s really no easy thing to pass the exam. In Pass4itSure, you can get a dump of the exam to help you easily pass the exam. It’s the best source for your exam material! Get the complete Microsoft DP-900 exam dumps here: https://www.pass4itsure.com/dp-900.html (PDF +VCE).

Comments are closed.