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.
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)
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.
Try our study magic for free
a PDF, study it super fast
- No sign up, email or credit card needed!
- AI makes unlimited flashcards
- Get unlimited quizzes and tests
- Ask AI anything
Create a notebook
- No sign up, email or credit card needed!
- Have and keep perfect overview
- Make flashcards, notes and mind maps
- Review, test and score!
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.
