You work as a Database Administrator (DBA) at ABC.com. The company has a SQL Server
2012 environment.
You have a requirement for a temporary application that stores data in a database. The
database must be highly available for one week while it is in use after which time the
database and application will be deleted.
You need to implement the database in the existing SQL Server environment whilst
ensuring that other databases are not affected.
Which of the following should you configure to meet the requirement?
A.
Blocked Process Threshold
B.
Processor affinity
C.
C2 Audit Mode
D.
Max Degree of Parallelism
Explanation:
Processor affinity applied on the server level, not database level. Seem like no good answer here.
No right answer here. The correct answer is:
Create a Contained Database…
…in the existing SQL environment for the temporary application.
how contained DB could be highly available?
I think the key requirement is “whilst ensuring that other databases are not affected”
so contained database seems to be a possible answer
The Question says “implement the database in the existing SQL Server environment”, which means a new database in the same SQL Server instance, with that in mind:
1 – Blocked Process Threshold is used to generate blocked process reports, so is the wrong answer.
2 – Processor affinity works on the Server Level, which means, would affect all the databases in the server, so is the wrong answer.
3 – C2 Audit Mode is used to help you profile system activity and track possible security policy violations, so is the wrong answer.
4 – Max Degree of Parallelism, defines the maximum number of processors the DATABASE can use, so this is the CORRECT answer.
https://msdn.microsoft.com/en-us/library/ee210585(v=sql.110).aspx
https://technet.microsoft.com/en-us/library/ms181007(v=sql.120).aspx
https://msdn.microsoft.com/en-us/library/ms187634(v=sql.120).aspx
https://msdn.microsoft.com/en-us/library/ms181150(v=sql.120).aspx
I don’t see a correct answer here…
4 – MDOP defines the maximum number of processors that single transaction can use – not database!