MTA DAF 5

Question 1

What role can you give to a user who gives full access to the SQL server and databases?

Answer 1

sysadmin

Question 2

What is used to grant a user account access to a database?

Answer 2

permission

Question 3

If you are using mixed mode, what account is the build-in SQL administrator account?

Answer 3

sa

Question 4

What command would you use to grant object permissions?

Answer 4

GRANT

Question 5

What is the act of establishing or confirming a user or system identity?

Answer 5

authentification

Question 6

What fixed database role allows you to have full permission to a database?

Answer 6

db_owner

Question 7

what fixed role allows you to create logins for the server?

Answer 7

securityadmin

Question 8

Which type of backup backs up only the data in the primary filegroup and specified files or filegroups?

Answer 8

partial backup

Question 9

If you need to restore a database after an incremental backup, what do you need to do for a restore?

Answer 9

Restore the backup and all the incremental backups since the last full backup.

Question 10

what role is automatically granted to all user?

Answer 10

public

Question 11

What fixed server role allows you to create, alter, and drop disk files?

Answer 11

diskadmin

Question 12

What permission would you assign that will remove the permission previously assigned?

Answer 12

revoke

Question 13

Which service account should you use if you need to have network access?

Answer 13

domain user account

Question 14

What fixed database role would you use to manage database-level security roles and permissions?

Answer 14

db_securityadmin

Question 15

Which type of backup backs up all changes since the last backup?

Answer 15

incremental backup