ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-765 All Questions

View all questions & answers for the 70-765 exam
Go to Exam

Exam 70-765 topic 1 question 12 discussion

Actual exam question from Microsoft's 70-765
Question #: 12
Topic #: 1
[All 70-765 Questions]

You plan to migrate a database To Microsoft Azure SQL Database. The database requires 500 gigabytes (GB) of storage.
The database must support 50 concurrent logins. You must minimize the cost associated with hosting the database.
You need to create the database.
Which pricing tier should you use?

  • A. Standard S3 pricing tier
  • B. Premium P2 tier
  • C. Standard S2 pricing tier
  • D. Premium P1 tier
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
For a database size of 500 GB the Premium tier is required.
Both P1 and P2 are adequate. P1 is preferred as it is cheaper.
Note:

Incorrect Answers:
A, C: Maximum database size is 250 GB for the Standard pricing tier.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers
by techiebuddhas at Feb. 7, 2020, 3:58 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
cmps
Highly Voted 5 years ago
I think correct is A. Standard S3 cost approximetly 175 €/month and is up to 1024 GB (max concurrent logins - 200). Premium P1 500GB - 390 €/month. If i have to minimize the cost i need to choose A.
upvoted 6 times
linabalkhi
4 years, 10 months ago
i agree with you
upvoted 2 times
...
axdev
4 years, 9 months ago
Agree P1 $/month = $0.6251 * 24 * 30 = $450 S3 $/month = $0.2017 * 24 * 30 = $145 + extra storage = 250GB*$0.17 = $42.5, total $187.5
upvoted 3 times
...
...
Iva10
Most Recent 4 years, 9 months ago
https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-single-databases A
upvoted 3 times
...
techiebuddhas
5 years, 3 months ago
this link is having clear clarity on the tiers https://azure.microsoft.com/en-us/pricing/details/sql-database/single/
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel