MENU
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?
Suggested Answer: D
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
12 comments · newest first
DU
Dusti
12 months ago
I thought an index would be enough, but I guess not!
LE
Lewis
1 year ago
A table would just complicate things.
SH
Sherell
1 year ago
Wait, can you really use a view for calculated columns?
LO
Lorrine
1 year ago
Totally agree, a view is the way to go.
LO
Louis
1 year ago
You should create a view for that!
ZI
Zita
1 year ago
I was leaning towards a scalar function, but now I'm questioning if that would really allow others to access the query easily.
KI
Kiera
1 year ago
I practiced a similar question, and I believe a view is the right choice because it can include calculated columns.
GE
Geraldo
1 year ago
I'm not entirely sure, but I remember something about tables being used for storing data, not queries.
WI
Wilson
1 year ago
I think we might need to create a view since it allows us to save the query and share it with others.
DA
Dallas
1 year ago
This question seems pretty straightforward. I'm pretty confident the answer is C, an object variable.
DE
Denae
1 year ago
I'm confident the answer is B. The Sales Manager needs the "Subscribe to Reports: Set Running User" permission to subscribe to the report created by the analyst.
JO
Jose
1 year ago
I remember we did a practice question on invoicing efficiency, so I want to select "Issue invoices quickly." That seems important!