Microsoft DP900 Exam Dumps|QAs Page -1

Last updated on October 16th, 2024 at 03:50 pm

Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.

Microsoft DP900 Exam Dumps – QAs 1-25

Q1. You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

1. zone-redundant storage (ZRS)
2. read-access geo-redundant storage (RA-GRS)
3. locally-redundant storage (LRS)
4. geo-redundant storage (GRS)

Q2. 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://azure.microsoft.com/en-us/overview/what-is-paas

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

Correct answer

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

Q5. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct answer

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

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

Correct answer

Q8. 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/architecture/data-guide/big-data/batch-processing

Q9. DRAG DROP –
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data type 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.
Select and Place:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling

Q10. DRAG DROP –
Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share

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

1. REVOKE
2. DISABLE
3. INSERT
4. GRANT

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

1. an index
2. a view
3. a scalar function
4. a table

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

Correct answer

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

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

Correct answer

Q15. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct answer

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

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

Correct answer

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

Q17. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct answer

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

Q18. DRAG DROP –
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Correct answer

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

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

Correct answer

Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

Q20. What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

1. Data is processed periodically
2. Low latency is expected
3. High latency is acceptable
4. Data is processed as it is created

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

Correct answer

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

Q22. HOTSPOT –
Select the answer that correctly completes the sentence.
Hot Area:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

Q23. DRAG DROP –
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization 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

Q24. DRAG DROP –
Match the Azure Data Factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Correct answer

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

Q25. 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.
Select and Place:

Correct answer

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