9640849
Descripción
Test por Hawerth Castro, actualizado hace más de 1 año
|
Creado por Hawerth Castro
hace más de 7 años
|
|
Pregunta 1
Pregunta
What is used to grant a user account access to a database?
Respuesta
-
permission
-
right
-
password
-
encryption key
Pregunta 2
Pregunta
What role can you give to a user who gives full access to the SQL server and databases?
Respuesta
-
root
-
system
-
sysadmin
-
local
Pregunta 3
Pregunta
What role is automatically granted to all users?
Respuesta
-
sysadmin
-
root
-
public
-
standard
Pregunta 4
Pregunta
What permission would you assign that will remove the permission previously assigned?
Respuesta
-
grant
-
denied
-
revoke
-
reset
Pregunta 5
Pregunta
What is the act of establishing or confirming a user or system identity?
Respuesta
-
authentication
-
authorization
-
auditing
-
logging
Pregunta 6
Pregunta
What fixed role allows you to create logins for the server?
Respuesta
-
dbcreator
-
diskadmin
-
securityadmin
-
serveradmin
Pregunta 7
Pregunta
If you are using mixed mode, what account is the build-in SQL administrator account?
Respuesta
-
administrator
-
sysadmin
-
root
-
sa
Pregunta 8
Pregunta
Which type of backup backs up all changes since the last backup?
Respuesta
-
full backup
-
differential backup
-
incremental backup
-
copy backup
Pregunta 9
Pregunta
Which type of backup backs up only the data in the primary filegroup and specified files or filegroups?
Respuesta
-
full backup
-
differential backup
-
partial backup
-
incremental backup
Pregunta 10
Pregunta
What fixed server role allows you to create, alter, and drop disk files?
Respuesta
-
bulkadmin
-
dbcreator
-
processadmin
-
diskadmin
Pregunta 11
Pregunta
Which service account should you use if you need to have network access?
Respuesta
-
local user account
-
local system account
-
domain user account
-
guest account
Pregunta 12
Pregunta
What fixed database role allows you to have full permission to a database?
Respuesta
-
sa
-
db_owner
-
db_datareader
-
db_accessadmin
Pregunta 13
Pregunta
What fixed database role would you use to manage database-level security roles and permissions?
Respuesta
-
sysadmin
-
db_securityadmin
-
db_accessadmin
-
db_datareader
Pregunta 14
Pregunta
What command would you use to grant object permissions?
Respuesta
-
GRANT
-
USE
-
RUNAS
-
ALLOW
Pregunta 15
Pregunta
If you need to restore a database after an incremental backup, what do you need to do for a restore?
Respuesta
-
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.
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.