Data security and compliance - Azure SQL databases

3 important questions on Data security and compliance - Azure SQL databases

On what levels can access be set?

Access can be set on the levels:
1. SQL server level.
2. Database level
3. Schema level
4. Table and view, procedure and functions level.

Which 2 special roles do azure sql databases have?

The two special roles are:
dbManager  (crud databases) and
login manager   (crud logins)

What is Transparant Data Encryption?

Encrypts database file at page level and are decrypted when read into memory, therefor it is encryption at rest. The SQL database automatically stores a server-level certificate in the master database and generates a private key.

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo