Exam 70-765 topic 3 question 83 discussion

Actual exam question from Microsoft's 70-765

Question #: 83
Topic #: 3

HOTSPOT -
You are building the database platform for a multi-tenant application. The application will have one database per tenant and will have at least 30 tenants. Each tenant will have a separate resource group for billing purposes.
The application will require at least 10 GB of clustered columnstore indexes for each database.
You need to implement the database platform for the application. The solution must minimize costs.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

The Standard tier service allows for 1TB of data. Here 30 x 10 GB, 0.3 TB, is required.
Incorrect Answers:
References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers

by STH at Sept. 8, 2019, 6:31 p.m.

Comments

Submit Cancel

MelKr

5 years, 2 months ago

Standard S3 and above support column store indexes (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-in-memory#in-memory-columnstore). Premium RS is deprecated.

upvoted 1 times

...

STH

5 years, 10 months ago

I thought the first answer was wrong, but it seems Standard tiers supports columnstore indexes since last year.

upvoted 3 times

...