Forty tenant SQL databases have independent brief peaks and must remain separate. Which two design actions are appropriate? Select 2 answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

A.Configure per-database limits alongside the shared pool budget
B.Promise every tenant its individual maximum at the same time regardless of total pool size
C.Evaluate an elastic pool sized for overlapping aggregate demand
D.Merge all databases because an elastic pool requires one shared schema

Show the answer and explanation

✓ Correct answers

Configure per-database limits alongside the shared pool budget
Evaluate an elastic pool sized for overlapping aggregate demand

An elastic pool shares capacity while keeping databases separate; limits constrain noisy tenants. It neither merges schemas nor makes aggregate capacity unlimited, so simultaneous maximum demand needs sufficient total resources. Source guide: PDF page 24-25.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.