Crucial Exams

Microsoft Azure Data Fundamentals DP-900 Practice Question

An online retail company stores data in Azure SQL Database. Customer information is kept in a Customers table, and each purchase is saved in an Orders table that includes a CustomerID column. The business wants a single query that returns every customer name together with the date of each order they placed. Which feature of relational data makes this possible?

  • The ability to join tables on matching key columns

  • Storage of nested arrays within a single column

  • Schema-on-read parsing of semi-structured data

  • Automatic horizontal scaling across multiple shards

Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot