exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 3 question 19 discussion

Actual exam question from Microsoft's AZ-305
Question #: 19
Topic #: 3
[All AZ-305 Questions]

HOTSPOT
-

You are building an Azure web app that will store the Personally Identifiable Information (PII) of employees.

You need to recommend an Azure SQL. Database solution for the web app. The solution must meet the following requirements:

• Maintain availability in the event of a single datacenter outage.
• Support the encryption of specific columns that contain PII.
• Automatically scale up during payroll operations.
• Minimize costs.

What should you include in the recommendations? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
zellck
Highly Voted 1 year, 9 months ago
1. GP service tier and Serverless compute tier 2. Always Encrypted https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The General Purpose service tier is designed for common workloads. It offers budget-oriented balanced compute and storage options. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#compute-tiers Serverless compute tier: auto-scales compute resources based on workload activity and bills for the amount of compute used, per second. The serverless compute tier is generally available in the General Purpose service tier, and is currently in preview in the Hyperscale service tier.
upvoted 49 times
zellck
1 year, 9 months ago
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16 Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or national identification numbers (for example, U.S. social security numbers), stored in Azure SQL Database, Azure SQL Managed Instance, and SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the Database Engine. This provides a separation between those who own the data and can view it, and those who manage the data but should have no access - on-premises database administrators, cloud database operators, or other high-privileged unauthorized users. As a result, Always Encrypted enables customers to confidently store their sensitive data in the cloud, and to reduce the likelihood of data theft by malicious insiders.
upvoted 3 times
...
...
NotMeAnyWay
Highly Voted 1 year, 8 months ago
1. Service tier and compute tier? b. General Purpose service tier and serverless compute tier The General Purpose service tier with serverless compute tier provides a cost-effective solution that meets the requirements. General Purpose tier supports zone-redundant configurations, which can maintain availability in the event of a single datacenter outage. The serverless compute tier automatically scales up or down based on workload, which is ideal for handling the increased load during payroll operations. 2. Encryption method? a. Always Encrypted Always Encrypted is the recommended encryption method for this scenario because it allows you to encrypt specific columns that contain PII. This ensures that sensitive data is encrypted both at rest and in transit, providing a higher level of security for PII. Transparent Data Encryption (TDE) encrypts the entire database at rest but does not provide column-level encryption, and Microsoft SQL Server and database encryption keys would involve additional manual configuration and management of keys.
upvoted 30 times
...
SeMo0o0o0o
Most Recent 3 weeks, 2 days ago
WRONG 1. General Purpose service tier and Serverless compute tier 2. Always Encrypted
upvoted 1 times
...
Arthur_zw
3 months ago
There is no serverless option for Business Critical tier of Azure SQL. Serverless is only available for the General Purpose and Hyperscale tiers as it only uses a single database
upvoted 3 times
...
23169fd
5 months, 2 weeks ago
Correct Business Critical service tier and Serverless compute tier: This tier ensures high availability with zone redundancy. Serverless compute tier allows automatic scaling during peak demand periods, such as payroll operations. Minimizes costs by scaling resources dynamically and pausing during inactivity. Encryption Method Always Encrypted: Supports column-level encryption, which is crucial for protecting PII. Ensures that sensitive data is encrypted both at rest and in transit. Provides robust security by keeping encryption keys on the client side.
upvoted 2 times
...
Lazylinux
7 months, 3 weeks ago
Agree with GP service tier and Serverless compute tier and Always Encrypted as side Note there is NO serveless option for business critical SQL - check for yourself when creating SQL in Azure portal
upvoted 4 times
...
varinder82
8 months, 2 weeks ago
Final Answer 1. GP service tier and Serverless compute tier 2. Always Encrypted
upvoted 4 times
...
eduardobbs
9 months ago
Got his on my exam on 06/Mar/24
upvoted 6 times
...
TomdeBom
9 months, 2 weeks ago
It is simple. The first option is wrong, because Business Critical with serverless compute tier is not supported! "The serverless compute tier is available in the General Purpose service tier and the Hyperscale service tier. " https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose Thus, it must be General Purpose service tier.
upvoted 5 times
...
JimmyYop
10 months, 2 weeks ago
appeared in Exam 01/2024
upvoted 7 times
...
YL123
10 months, 3 weeks ago
Answer should be correct. It has to be BC service tier, because the requirement is "Maintain availability in the event of a single datacenter outage." GP service tier will have several minutes down time when there is an outage happened.
upvoted 3 times
TonySuccess
10 months, 1 week ago
My research is also pointing me in this direction, so I wonder if since the people who originally commented, something has changed.
upvoted 2 times
...
...
Risto83
10 months, 4 weeks ago
Business critical is the one with seconday replicas https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql
upvoted 1 times
...
Som_triv
1 year, 2 months ago
Serverless compute tier : Service tier- General Purpose and Hyperscale (in Preview) Ans : 1. GP with Serverless compute tier 2. Always Encrypted
upvoted 1 times
...
Tr619899
1 year, 5 months ago
For this scenario, I would recommend using the General Purpose service tier with the Serverless compute tier for the Azure SQL Database solution. This configuration provides cost-effective storage and compute resources that can automatically scale up during periods of high demand, such as during payroll operations. To support the encryption of specific columns that contain PII, you can use the Always Encrypted feature. This feature allows you to encrypt sensitive data within client applications and never reveal the encryption keys to the database engine. This helps to ensure that sensitive data remains protected at all times, even if the database is compromised.
upvoted 4 times
...
lvz
1 year, 6 months ago
As of 27-05-2023, I am trying to figure out if there is such a thing called Azure sql business critical, serverless tier. I don't see one. I have been searching, neither Premium has serverless tier, only general purpose do. So if anyone is aware of it, please share the link below the post. thx
upvoted 4 times
nakacom
1 year, 6 months ago
https://learn.microsoft.com/en-us/azure/azure-arc/data/service-tiers
upvoted 2 times
...
...
VBK8579
1 year, 10 months ago
For the Service tier and computer tier, you should recommend "General Purpose service tier and Provisioned compute tier". For the Encryption method, you should recommend "Always Encrypted".
upvoted 4 times
...
jwjwjw
1 year, 10 months ago
First box is "General Purpose": Zone-redundant configuration for the General Purpose service tier is offered for both serverless and provisioned compute. https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 2 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
Loading ...