MENU
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
Suggested Answer: B
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
CE
Celestina
12 months ago
Yeah, ALTER is definitely the correct choice here!
IS
Isreal
1 year ago
I thought INSERT was for adding data, not columns.
GR
Grover
1 year ago
Wait, can you really use ALTER for views?
GW
Gwen
1 year ago
Totally agree, ALTER is the way to go!
AR
Armando
1 year ago
You should use ALTER to add a new column.
RE
Rebecka
1 year ago
I thought UPDATE was for changing data within a view, not the structure. This is tricky!
CH
Chantay
1 year ago
I feel like ALTER is the right choice here, but I might be mixing it up with how we modify tables.
AN
Annmarie
1 year ago
I think we need to use ALTER for modifying the structure of a view, but I'm not entirely sure.
CA
Carmela
1 year ago
I remember practicing a question about adding columns to tables, but views might be different. Could it be INSERT instead?
EL
Elizabeth
1 year 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.
GO
Golda
1 year 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.
AL
Alease
1 year 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.