Pass Your Microsoft Certified: Azure Data Fundamentals DP-900 Exam on Jun 25, 2023 with 260 Questions
DP-900 Free Exam Study Guide! (Updated 260 Questions)
NEW QUESTION # 121
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?
- A. Azure SQL Database Hyperscale
- B. Azure SQL managed instance
- C. Azure SQL Database elastic pod
- D. Azure SQL Database serveless
Answer: B
NEW QUESTION # 122
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.
Answer:
Explanation:
NEW QUESTION # 123
Select the answer the correctly completes the sentence.
Answer:
Explanation:
Answer below as:
NEW QUESTION # 124
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://azure.microsoft.com/en-us/overview/what-is-saas/
https://azure.microsoft.com/en-us/overview/what-is-paas/
NEW QUESTION # 125
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION # 126
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.
Answer:
Explanation:
NEW QUESTION # 127
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:

NEW QUESTION # 128
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown for the fourth quarter?
- A. diagnostic
- B. prescription
- C. predictive
- D. descriptive
Answer: C
Explanation:
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
NEW QUESTION # 129
Select the answer that correctly completes the sentence.
Answer:
Explanation:
See the answer in explanation below.
Answer below as:
NEW QUESTION # 130
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
NEW QUESTION # 131
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:

NEW QUESTION # 132
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
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/
NEW QUESTION # 133
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf
https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/sqldw-walkthrough
NEW QUESTION # 134
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:

NEW QUESTION # 135
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
NEW QUESTION # 136
To complement the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION # 137
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
https://docs.microsoft.com/en-us/azure/media-services/previous/media-services-index-content
NEW QUESTION # 138
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
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/
NEW QUESTION # 139
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs
NEW QUESTION # 140
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://azure.microsoft.com/en-us/overview/what-is-paas
https://feedback.azure.com/forums/217321-sql-database/suggestions/6931152-please-add-ability-to-temporarily-turn-off-on-sql
NEW QUESTION # 141
Select the answer that correctly completes the sentence.
Answer:
Explanation:
NEW QUESTION # 142
You have the following SQL query.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 143
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION # 144
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION # 145
......
DP-900 Dumps for Microsoft Certified: Azure Data Fundamentals Certified Exam Questions and Answer: https://www.troytecdumps.com/DP-900-troytec-exam-dumps.html
Realistic Verified DP-900 exam dumps Q&As - DP-900 Free Update: https://drive.google.com/open?id=1cBZSgAXnDg_1fe1I0uw2dvpK1egt3U0s