nerdexam
MicrosoftMicrosoft

DP-900 · Question #55

DP-900 Question #55: Real Exam Question with Answer & Explanation

The correct arrangement matches each database object to its core description: a Table is the fundamental database object that stores raw data in rows and columns; a View is a virtual table based on a stored query that presents data from one or more tables without storing data its

Submitted by kevin_r· Mar 30, 2026Understanding core relational database structures and objects, including tables, views, and indexes - commonly tested in database administration, data analyst, or foundational IT certification exams (e.g., CompTIA Data+, Oracle Database Foundations, Microsoft Azure Data Fundamentals DP-900).

Question

Drag and Drop Question Match the terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Answer:

Explanation

The correct arrangement matches each database object to its core description: a Table is the fundamental database object that stores raw data in rows and columns; a View is a virtual table based on a stored query that presents data from one or more tables without storing data itself; and an Index is a performance-optimization structure that speeds up data retrieval by creating pointers to rows in a table. These distinctions reflect the foundational roles each object plays in relational database design.

Topics

#Database Objects#Relational Databases#SQL Fundamentals#Data Management

Community Discussion

No community discussion yet for this question.

Full DP-900 PracticeBrowse All DP-900 Questions