Questão 1
Questão
What is used to grant a user account access to a database?
Responda
-
permission
-
right
-
password
-
encryption key
Questão 2
Questão
What role can you give to a user who gives full access to the SQL server and databases?
Responda
-
root
-
system
-
sysadmin
-
local
Questão 3
Questão
What role is automatically granted to all users?
Responda
-
sysadmin
-
root
-
public
-
standard
Questão 4
Questão
What permission would you assign that will remove the permission previously assigned?
Responda
-
grant
-
denied
-
revoke
-
reset
Questão 5
Questão
What is the act of establishing or confirming a user or system identity?
Responda
-
authentication
-
authorization
-
auditing
-
logging
Questão 6
Questão
What fixed role allows you to create logins for the server?
Responda
-
dbcreator
-
diskadmin
-
securityadmin
-
serveradmin
Questão 7
Questão
If you are using mixed mode, what account is the build-in SQL administrator account?
Responda
-
administrator
-
sysadmin
-
root
-
sa
Questão 8
Questão
Which type of backup backs up all changes since the last backup?
Responda
-
full backup
-
differential backup
-
incremental backup
-
copy backup
Questão 9
Questão
Which type of backup backs up only the data in the primary filegroup and specified files or filegroups?
Responda
-
full backup
-
differential backup
-
partial backup
-
incremental backup
Questão 10
Questão
What fixed server role allows you to create, alter, and drop disk files?
Responda
-
bulkadmin
-
dbcreator
-
processadmin
-
diskadmin
Questão 11
Questão
Which service account should you use if you need to have network access?
Responda
-
local user account
-
local system account
-
domain user account
-
guest account
Questão 12
Questão
What fixed database role allows you to have full permission to a database?
Responda
-
sa
-
db_owner
-
db_datareader
-
db_accessadmin
Questão 13
Questão
What fixed database role would you use to manage database-level security roles and permissions?
Responda
-
sysadmin
-
db_securityadmin
-
db_accessadmin
-
db_datareader
Questão 14
Questão
What command would you use to grant object permissions?
Questão 15
Questão
If you need to restore a database after an incremental backup, what do you need to do for a restore?
Responda
-
Restore the full backup and the first incremental backup.
-
Restore the full backup and the last incremental backup.
-
Restore the full backup and all the incremental backups since the last full backup.
-
Restore the last incremental backup.