Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-900

Microsoft DP-900 Exam Questions
Microsoft Azure Data Fundamentals (Page 10 )

Updated On: 24-Feb-2026
Page 10 of 63
PDF with 314 Questions

HOTSPOT (Drag and Drop is not supported)
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15



DRAG DROP (Drag and Drop is not supported)
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




Box 1: Diagnostic
Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.
Box 2: Prescriptive
Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.
Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome
Box 3: Cognitive


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/



HOTSPOT (Drag and Drop is not supported)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Which type of database is Azure Database for PostgreSQL?

  1. Platform as a service (PaaS)
  2. Infrastructure as a service (IaaS)
  3. Microsoft SQL Server
  4. on-premises

Answer(s): A


Reference:

https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options



Which storage solution supports access control lists (ACLs) at the file and folder level?

  1. Azure Data Lake Storage
  2. Azure Queue storage
  3. Azure Blob storage
  4. Azure Cosmos DB

Answer(s): A

Explanation:

Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).


Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control






Post your Comments and Discuss Microsoft DP-900 exam dumps with other Community members:

Join the DP-900 Discussion