Exam 98-364 All Questions

View all questions & answers for the 98-364 exam

Exam 98-364 topic 1 question 90 discussion

Actual exam question from Microsoft's 98-364

Question #: 90
Topic #: 1

This question requires that you evaluate the underlined text to determine if it is correct.
A view can be used to ensure referential integrity.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

A. No change is needed.
B. Save an extra copy of data stored in a separate table.
C. Limit access to specific rows or columns of data in a table.
D. Save historical data before deleting it from the base table.

Show Suggested Answer

Suggested Answer: C 🗳️

by hgroeder at Aug. 7, 2019, 8:29 a.m.

Comments

Submit Cancel

Aaabbbaaa

Highly Voted 5 years, 7 months ago

This is the underlined text “ ensure referential integrity.”

upvoted 13 times

...

Garyours

Highly Voted 4 years, 10 months ago

Those saying the underlying text is missing should read the question well. This is asking you what views can be used for so the answer is C

upvoted 5 times

...

emka_ka

Most Recent 3 years, 4 months ago

Selected Answer: C

limits...

upvoted 1 times

...

Slife

5 years, 4 months ago

The "underlined text" is there but it is not actually underlined. The "underlined text" is the sentence above the Instructions.

upvoted 1 times

...

Pryns

5 years, 8 months ago

Underlined text is "view"

upvoted 2 times

Marcilla

4 years, 4 months ago

Isn't it "ensure referential integrity"?

upvoted 1 times

...

emka_ka

3 years, 4 months ago

No. The second part of the sentence is the underlined part, because the options B C D follow the same syntax. If that was 'view' the options also would be database objects or nouns, not statements of functionality. And a view indeed limits access to certain columns/rows. So a view + C makes perfect sense.

upvoted 1 times

...

yolande1789

5 years, 12 months ago

Where is the underlined text?

upvoted 1 times

...

hgroeder

5 years, 12 months ago

The "underlined text" is missing

upvoted 1 times

...