Multiple Choice Questions - Contained Databases
1) A contained database is one that is isolated from other databases but may or may not be isolated from the instance of SQL Server that it is running on.
A) True
B) False
2) In SQL Server 2012, all databases are still, by default, . . . . . . . . . . .
A) partially contained
B) contained
C) non-contained
D) None of above
3) With partially contained databases not all the users need to be . . . . . . . . . Partially contained databases can have a combination of . . . . . . . . . . and . . . . . . . . . within the database.
A) contained users, contained users, non-contained users
B) contained users, system users, non-contained users
C) system users, contained users, non-contained users
D) contained users, contained users, remote users
4) Advantages of contained databases: (choose all that apply)
A) Portability of the database.
B) Good candidates for AlwaysOn
C) No need to explicitly specify the database in the connection string.
D) Reducing administrative overhead
E) Database mirroring
5) A fully contained databases has no external dependencies like logins or references to other databases, making it easier to move between servers without breaking any functionality.
A) True
B) False
6) Two key steps which are required to create a partially contained database in SQL Server 2012 are:
A) The first step is to delete non-contained databases . The next step is to configure the database for containment.
B) The first step is to disable non-contained databases. The next step is to configure the database for containment.
C) The first step is to enable root configuration. The next step is to configure the database for containment.
D) The first step is to enable contained database authentication. The next step is to configure the database for containment.
7) Partially contained databases do not store the . . . . . . . So you still need to replicate the . . . . . . . . . to all the secondary replicas.
A) jobs
B) user information
C) system views
D) authentication information
8) SQL Server provides a new data management view (DMV) called . . . . . . . . . . that you can query on to discover potential threats to database portability.
A) sys.sql_modules
B) sys.dm_db_uncontained_entities
C) sys.dm_db_resource_stats
D) sys.dm_db_persisted_sku_features
9) A contained database cannot use . . . . . . . . . . .
A) replication
B) change tracking
C) change data capture
D) all of above
10) In the contained model, a database user is created with a password and cannot be mapped to a windows user.
A) True
B) False
Answers