You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist the SQL query so that other users can use the query. What should you create?

The correct answer is D. a view. A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases…

Submitted by yousef_jo· Mar 30, 2026Identify considerations for relational data on Azure

Question

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist the SQL query so that other users can use the query. What should you create?

Options

Aa table
Ban index
Cscalar function
Da view

How the community answered

(62 responses)

A
3% (2)
B
6% (4)
C
10% (6)
D
81% (50)

Explanation

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases. https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Topics

#SQL views#T-SQL#calculated columns#database objects

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice