Home » Microsoft » 70-466 v.2 » Which advanced server option should you modify?
You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance. The application generates all T-SQL statements dynamically and does not use stored procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?
A. Scan for Startup Procs
B. Allow Triggers to Fire Others
C. Enable Contained Databases
D. Optimize for Ad hoc Workloads
Correct Answer: C
Explanation/Reference:
Explanation:
A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. SQL Server helps user to isolate their database from the instance in 4 ways.
Much of the metadata that describes a database is maintained in the database. (In addition to, or instead of, maintaining metadata in the master database.) All metadata are defined using the same collation.
User authentication can be performed by the database, reducing the databases dependency on the logins of the instance of SQL Server. The SQL Server environment (DMV’s, XEvents, etc.) reports and can act upon containment information.
References: https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases