Online Access Free 70-459 Exam Questions

DRAG DROP
You plan to deploy SQL Server 2012.
Your company identifies the following monitoring requirements:
- Tempdb must be monitored for insufficient free space.
- Deadlocks must be analyzed by using Deadlock graphs. You need to identify which feature meets each monitoring requirement.
Which features should you identify?
To answer, drag the appropriate feature to the correct monitoring requirement in the answer area.

Correct Answer:

You need to recommend a solution to allow application users to perform UPDATE operations on the database tables. The solution must meet the business requirements.
What should you recommend?

• A.Create stored procedures that use EXECUTE AS clauses.
• B.Create a user-defined database role and add users to the role.
• C.Create a Policy-Based Management Policy.
• D.Create functions that use EXECUTE AS clauses.

You have a server named Server1 that has 16 processors.
You plan to deploy multiple instances of SQL Server 2012 to Server1.
You need to recommend a method to allocate processors to each instance.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Windows System Resource Manager (WSRM)
• B.Resource Governor
• C.Max Degree of Parallelism
• D.Processor affinity

You need to add a new column named Confirmed to the Attendees table. The solution must meet the following requirements:
- Have a default value of false. - Minimize the amount of disk space used.
Which code block should you use?

• A.ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 1;
• B.ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 0;
• C.ALTER TABLE Attendees
  ADD Confirmed char(1) DEFAULT '1';
• D.ALTER TABLE Attendees
  ADD Confirmed char(1) DEFAULT '0';

You execute usp_TestSpeakers.
You discover that usp_SelectSpeakersByName uses inefficient execution plans.
You need to update usp_SelectSpeakersByName to ensure that the most efficient execution plan is used.
What should you add at line 30 of Procedures.sql?

• A.OPTION (FORCESEEK)
• B.OPTION (OPTIMIZE FOR UNKNOWN)
• C.OPTION (OPTIMIZE FOR (@LastName = 'Anderson'))
• D.OPTION (FCRCESCAN)