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 2 Question 41 Discussion

You need to modify a view in a relational database by adding a new column.Which statement should you use?
B) ALTER
A) MERGE
C) INSERT
D) UPDATE

Microsoft DP-900 Exam - Topic 2 Question 41 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 41
Topic #: 2
[All DP-900 Questions]

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Portia at May 03, 2022, 06:47 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
Celestina
10 months ago
Yeah, ALTER is definitely the correct choice here!
upvoted 0 times
...
Isreal
10 months ago
I thought INSERT was for adding data, not columns.
upvoted 0 times
...
Grover
11 months ago
Wait, can you really use ALTER for views?
upvoted 0 times
...
Gwen
11 months ago
Totally agree, ALTER is the way to go!
upvoted 0 times
...
Armando
11 months ago
You should use ALTER to add a new column.
upvoted 0 times
...
Rebecka
11 months ago
I thought UPDATE was for changing data within a view, not the structure. This is tricky!
upvoted 0 times
...
Chantay
11 months ago
I feel like ALTER is the right choice here, but I might be mixing it up with how we modify tables.
upvoted 0 times
...
Annmarie
11 months ago
I think we need to use ALTER for modifying the structure of a view, but I'm not entirely sure.
upvoted 0 times
...
Carmela
11 months ago
I remember practicing a question about adding columns to tables, but views might be different. Could it be INSERT instead?
upvoted 0 times
...
Elizabeth
11 months ago
This question seems straightforward. I'll carefully read through the options and eliminate the ones that are clearly described as techniques used by auditors.
upvoted 0 times
...
Golda
11 months ago
I'm pretty confident that the correct answer is A. Only an Integration Knowledge Module single-technology is required, since the data stores are on the same server.
upvoted 0 times
...
Alease
11 months ago
Hmm, I'm not sure about this one. I'll have to think it through carefully. Entering it as an unapplied receipt or on-account receipt doesn't seem quite right since we don't have the customer details.
upvoted 0 times
...

Save Cancel