Exam 98-364 topic 1 question 7 discussion

Actual exam question from Microsoft's 98-364

Question #: 7
Topic #: 1

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table.
At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?

A. The Customer table no longer exists.
B. The Customer table is unaffected.
C. The Customer table exists but has no data.
D. The script fails.

Show Suggested Answer

Suggested Answer: A 🗳️

by Deehjosh at Nov. 21, 2019, 2:22 a.m.

Comments

Submit Cancel

kingsleyloh

3 years, 6 months ago

Table was created after backup so it will not exist when restored

upvoted 2 times

...

SIMPLE_TRAP

4 years, 3 months ago

can the ans be explained ?

upvoted 1 times

Marcilla

4 years, 2 months ago

The attempt to create the customer table occurred after the backup. Therefore, when the backup is restored, it is as if no attempt had yet been made to create a customer table

upvoted 3 times

...

Deehjosh

5 years, 6 months ago

the answer is A

upvoted 2 times

...