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