Microsoft Azure Data Fundamentals (DP-900) Free Practice Test

Question 1

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

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

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

C. You need to audit the transactional application.

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

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Match the data processing languages to the appropriate real-time analytics services.
To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Correct Answer:

Question 3

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. role-based access control (RSAC)

B. Dynamic Host Configuration Protocol (DHCP)

C. Domain Name Service (DNS)

D. a database-level firewall

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Select the answer that correctly completes the sentence.

Correct Answer:

See the answer below:
Explanation:
Answer as below.

Question 5

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.

A. database

B. item

C. container

D. partition

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

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

Correct Answer:

Reference:
https://docs.microsoft.c om/en-us/azure/security/fundamentals/infrastructure-sql

Question 7

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

A. atomicity

B. consistency

C. isolation

D. durability

Correct Answer: A

Question 8

Select the answer that correctly completes the sentence.