Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam
Go to Exam

Exam DP-900 topic 1 question 19 discussion

Actual exam question from Microsoft's DP-900
Question #: 19
Topic #: 1
[All DP-900 Questions]

You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?

  • A. an index
  • B. a view
  • C. a scalar function
  • D. a table
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Claudio_Ale at Oct. 6, 2021, 2:25 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
puksometron
Highly Voted 3 years, 1 month ago
Answer is correct
upvoted 30 times
...
heenak55
Highly Voted 2 years, 7 months ago
In exam 21 April 2022
upvoted 5 times
...
man5484
Most Recent 1 week, 5 days ago
A. Incorrect. An index is used to improve the speed of data retrieval and does not store a query or combine tables. B. Correct. A view is a virtual table based on a SQL query that combines data from multiple tables and can include calculated columns. Other users can rerun the query by simply querying the view, making it an ideal choice for reusing a specific query. C. Incorrect. A scalar function returns a single value based on input parameters, not a result set of combined data from multiple tables. D. Incorrect. A table stores data but does not directly store a query. Creating a table would require duplicating data rather than reusing a specific query.
upvoted 1 times
...
the_jigglypuff
1 month, 2 weeks ago
I would create a view
upvoted 1 times
...
toussdev
7 months, 1 week ago
Selected Answer: B
Answer B. View can be used by other users
upvoted 1 times
...
AGTraining
9 months ago
Option B
upvoted 1 times
...
trashbox
1 year ago
Selected Answer: B
Appeared on 2023-11-05.
upvoted 1 times
...
kjszala
1 year, 2 months ago
Selected Answer: B
Correct
upvoted 3 times
...
TKC_2023
1 year, 2 months ago
Selected Answer: B
correct
upvoted 1 times
...
hcq31818
1 year, 2 months ago
Selected Answer: B
View is the correct answer
upvoted 1 times
...
AZFabio
1 year, 2 months ago
Selected Answer: B
A view allows you to reuse a query
upvoted 1 times
...
MannyJZ
1 year, 3 months ago
On exam today 08/08/23
upvoted 1 times
...
akhil5432
1 year, 3 months ago
OPTION B
upvoted 1 times
...
rohirag
1 year, 4 months ago
Selected Answer: B
Create a VIEW
upvoted 1 times
...
VNR25
1 year, 4 months ago
This question appeared in the 07/07/23 exam and the answer is correct.
upvoted 1 times
...
vicks60
1 year, 7 months ago
Selected Answer: B
View is correct answer
upvoted 2 times
...
chiiiweiii
1 year, 8 months ago
Selected Answer: B
Correct Answer.
upvoted 2 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel