Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-900 Exam - Topic 4 Question 16 Discussion

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?
D) a view
A) a table
B) an index
C) scalar function

Microsoft DP-900 Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Dusti
10 months ago
I thought an index would be enough, but I guess not!
upvoted 0 times
...
Lewis
10 months ago
A table would just complicate things.
upvoted 0 times
...
Sherell
11 months ago
Wait, can you really use a view for calculated columns?
upvoted 0 times
...
Lorrine
11 months ago
Totally agree, a view is the way to go.
upvoted 0 times
...
Louis
11 months ago
You should create a view for that!
upvoted 0 times
...
Zita
11 months ago
I was leaning towards a scalar function, but now I'm questioning if that would really allow others to access the query easily.
upvoted 0 times
...
Kiera
11 months ago
I practiced a similar question, and I believe a view is the right choice because it can include calculated columns.
upvoted 0 times
...
Geraldo
11 months ago
I'm not entirely sure, but I remember something about tables being used for storing data, not queries.
upvoted 0 times
...
Wilson
11 months ago
I think we might need to create a view since it allows us to save the query and share it with others.
upvoted 0 times
...
Dallas
11 months ago
This question seems pretty straightforward. I'm pretty confident the answer is C, an object variable.
upvoted 0 times
...
Denae
11 months 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.
upvoted 0 times
...
Jose
11 months ago
I remember we did a practice question on invoicing efficiency, so I want to select "Issue invoices quickly." That seems important!
upvoted 0 times
...

Save Cancel