Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Exam Practice Test Questions

• Question 1

  Which Azure Data Factory component initiates the execution of a pipeline?

  • A control flow
  • A trigger
  • A parameter
  • An activity

  Show Answer Answer: B Next

• Question 2

  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?

  • Azure DNS
  • Azure Application Gateway
  • Azure Private link
  • Azure Traffic Manager

  Show Answer Answer: C Next

• Question 3

  What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

  • Normalized data
  • Schema defined in a database
  • Schema defined when reading unstructured data from a database
  • Normalized data
  • Light writes and heavy reads
  • Heavy writes and moderate reads

  Show Answer Answer: A, C, F Next

• Question 4

  You need to store data in Azure Blob storage for seven years to meet your company's compliancerequirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.Which storage tier should you use?

  • Archive
  • Hot
  • Cool

  Show Answer Answer: A Next

• Question 5

  A bar chart showing year-to date sales by region is an example of which type of analytics?

  • Descriptive
  • Diagnostic
  • Predictive
  • Prescriptive

  Show Answer Answer: B Next