QUESTION 21
You have four databases that are accessed by using an Online Transaction Processing (OLTP) application. The databases are stored on a server named SQL1
that has SQL Server 2016 installed.
You plan to deploy an additional server that has SQL Server 2016 installed.
You need to design a high-availability solution for the databases that meets the following requirements:
If SQL1 fails, the databases must be available.
Users must be able to run reports against a secondary copy of the databases.
What should you include in the design?
More than one answer choice may achieve the goal. Select the BEST answer.
A. AlwaysOn availability groups
B. Database mirroring
C. Log shipping
D. Failover Clustering
Correct Answer: A
Explanation
Explanation/Reference:
The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.
Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. An availability group
supports a failover environment for a discrete set of user databases, known as availability databases that fail over together.
Reference: Failover and Failover Modes (AlwaysOn Availability Groups)
70-686 dumps
QUESTION 22
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in
the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are examining information about users, sessions, and processed in an on-premises Microsoft SQL Server Database Engine instance.
You need to return information about processes that are not idle, that belong to a specific user, or that belong to a specific session.
What should you use?
A. Activity Monitor
B. sp_who3
C. SQL Server Management Studio (SSMS) Object Explorer
D. SQL Server Data Collector
E. SQL Server Data Tools (SSDT)
F. SQL Server Configuration ManagerCorrect Answer: B
Explanation
Explanation/Reference:
Use sp_who3 to first view the current system load and to identify a session of interest. You should execute the query several times to identify which session id is
most consuming teh system resources.
Parameters
sp_who3 null – who is active;
sp_who3 1 or ‘memory’ – who is consuming the memory; sp_who3 2 or ‘cpu’ – who has cached plans that consumed the most cumulative CPU (top
10);
sp_who3 3 or ‘count’ – who is connected and how many sessions it has; sp_who3 4 or ‘idle’ – who is idle that has open transactions; sp_who3 5 or ‘tempdb’ – who
is running tasks that use tempdb (top 5); and, sp_who3 6 or ‘block’ – who is blocking
We have skilled professionals ready to take on all your email support and marketing related responsibilities. So that you can focus on the things that really matters
