Microsoft Exam DP-900 Topic 4 Question 16 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 16
Topic #: 4

[All DP-900 Questions]

You have a SQL query that combines customer data and order dat

a. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query. What should you create?

Aa table

Ban index

Cscalar function

Da view

Show Suggested Answer

Suggested Answer: D

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

by Jesusa at May 08, 2022, 10:02 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!