98-364 Dumps With Real Exam Question - Free 98-364 Study Material

Question No 5

In which situation do you need to perform a restore on a database?

A. when data becomes corrupted in the database
B. when you need to roll back a transaction
C. when you encounter an error in your application
D. when data needs to be deleted from the database

Answer: A

98-364 Practice Test Exam

Latest 98-364 Exam Questions - Free 98-364 Full Training

Question No 4

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.

Answer: A

Free 98-364 Actual Exam Dumps - 98-364 Practice Questions

Question No 3

Which key uniquely identifies a row in a table?

A. foreiqn
B. primary
C. local
D. superkey

Answer: B

Free Microsoft 98-364 Braindumps - Pass 98-364 Exam - Dumps4download

Question No 2

One reason to add an index is to:

A. Decrease storage space.
B. Increase database security.
C. Improve performance of select statements.
D. Improve performance of insert statements.

Answer: C

Free 98-364 Real Exam Questions - Free 98-364 Dumps PDF

Question  No 1

The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

A. View
B. Function
C. Index
D. Stored procedure
E. Trigger

Answer: C

98-364 Practice Test