Backups
What are the three basic types of database backups?
What are transaction log, differential and full backups.
What are the main types of recovery model settings?
What is full, bulk-logged or simple.
How to change the compatibility mode?
What is a database.
What is the max database size for SQL Server 2016-2019 Express Edition?
What is 10 GB.
Which editions of 2016 provide Server + CAL licensing option? *
*Existing agreement with Microsoft
What are Enterprise and Standard editions.
Why are backups required?
What is to restore and recover the data in case of disaster, failure or restore to another environment.
How do you set expiration dates for backups?
What is WITH EXPIREDATE clause option in the backup database T-SQL
or
What is 'backup set will expire' option with SSMS backup.
Where is 'show advanced options' enabled?
What is an Instance. sp_configure 'show advanced options', 1;
Which edition does not provide any HA option?
What is Express edition.
Witness only for Database mirroring.
Does truly passive secondary server used for failover support need to licensed separately?
What is no.
If it’s serving data, such as reports to clients running active workloads, additional backups; then, it must be licensed.
What is required before performing differential or transaction log backups?
What is a full backup.
What are the recommended backup recovery point for a database?
What is the recovery point in time requirements.
Recommendation is weekly full, daily differential and hourly transaction logs.
Is backup compression set as default?
What is an Instance. Default is 0, off
What is the maximum memory for buffer pool per instance of SQL Server Database Engine?
What is 128 GB.
Which versions are considered free edition, even with an existing agreement with Microsoft?
What are Express and Developer.
What type of backup excludes read-only filegroups?
What is a partial backup.
Can you validate database backups are restorable?
What is yes.
RESTORE VERIFYONLY command, restore backups regularly, log shipping.
Where is CLR enabled?
What is an Instance. Default is 0, off
What is the maximum memory utilized per instance of Reporting Services within Enterprise Edition?
What is the operating system maximum.
Standard Edition is 64 GB.
What is the minimum core licenses required for each physical processor on a server?
What is four.
What types of backups are supported for Bulk-logged recovery model?
What are full, differential, transaction log, file and/or filegroup, partial, copy-only backups.
Can you recover an encrypted a database backup to a new instance?
What is yes.
Master key, certificate and database encryption key are required.
Where are nested triggers enabled?
What is a database. Triggers can be nested to a maximum of 32 levels.
Which editions provides Advanced HA?
What are Enterprise and Developer editions.
Which editions are considered for mission critical applications or large scale data warehousing?
What is Enterprise Edition.