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?

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

Dusti

4 months ago

I thought an index would be enough, but I guess not!

upvoted 0 times

...

Lewis

4 months ago

A table would just complicate things.

upvoted 0 times

...

Sherell

4 months ago

Wait, can you really use a view for calculated columns?

upvoted 0 times

...

Lorrine

5 months ago

Totally agree, a view is the way to go.

upvoted 0 times

...

Louis

5 months ago

You should create a view for that!

upvoted 0 times

...

Zita

5 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

5 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

5 months ago

I'm not entirely sure, but I remember something about tables being used for storing data, not queries.

upvoted 0 times

...

Wilson

5 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

5 months ago

This question seems pretty straightforward. I'm pretty confident the answer is C, an object variable.

upvoted 0 times

...

Denae

5 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

5 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

...