PrepAway - Latest Free Exam Questions & Answers

how can you be assured necessary resources will be available when the query is run?

If your CEO runs a query each day, how can you be assured necessary resources will be available
when the query is run? (Select two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Create a resource pool with dedicated resources for the CEO.

B.
Move all other users out of the general pool, leaving the CEO as the only user in the general
pool.

C.
Reserve one core for use by the CEO user only.

D.
Assign the CEO user to the general resource pool with a high MEMORYCAP.

E.
Profile the query to determine estimated resource usage.

Explanation:


Leave a Reply