CET_TARDE - MTA Database - DIAGNOSTIC5

Descrição

Database Fundamentals Quizzes preparing to certification
Hawerth Castro
Quiz por Hawerth Castro, atualizado more than 1 year ago
Hawerth Castro
Criado por Hawerth Castro mais de 7 anos atrás
36
0

Resumo de Recurso

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?
Responda
  • GRANT
  • USE
  • RUNAS
  • ALLOW

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.

Semelhante

CET_TARDE - MTA Database - E_COMANDS
Hawerth Castro
CET_TARDE - MTA Database - E_backup_permissions
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 5
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 6
Hawerth Castro
CET_TARDE - MTA Database - INDEX
Hawerth Castro
CET_TARDE - MTA Database - DIAGNOSTIC4
Hawerth Castro
CET_TARDE - MTA HTML5 Application Development Fundamentals 2
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Mobility and Devices Fundamentals 1
Hawerth Castro