CET_TARDE - MTA Database - DIAGNOSTIC5

Beschreibung

Database Fundamentals Quizzes preparing to certification
Hawerth Castro
Quiz von Hawerth Castro, aktualisiert more than 1 year ago
Hawerth Castro
Erstellt von Hawerth Castro vor mehr als 7 Jahre
36
0

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

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.
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

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