DP-900 Practice Exams and Training Solutions for Certifications [Q40-Q60]

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

QUESTION 41
You have the following SQL query.

NOTE: Each correct selection is worth one point.

QUESTION 42
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?

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

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

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

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

QUESTION 47
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?

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

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

QUESTION 50
Select the answer that correctly completes the sentence.

QUESTION 51
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers
require code assistance features such as intellSense.
What should the developers use ?

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

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

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

QUESTION 55
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?

QUESTION 56
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?

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

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

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

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