SQL

Question 1

Elastic Pools

Answer 1

a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price.

Question 2

Dynamic Data Masking

Answer 2

Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. It’s a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database is not changed.

Question 3

Row-Level Security

Answer 3

RLS helps you implement restrictions on data row access. For example, you can ensure that workers access only those data rows that are pertinent to their department, or restrict customers’ data access to only the data relevant to their company.

Question 4

Transparent Data Encryption

Answer 4

Real time encryption and decryption of the database, backups and transaction log files at rest.

Question 5

Query Store

Answer 5

Query Store in Azure is a fully managed database feature that continuously collects and presents detailed historic information about all queries. Using this pre-collected query data, you can quickly diagnose and resolve performance problems and thus spend more time focusing on their business.