Chunkey Monkey Diet

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

SY0-401 dumps

QUESTION 23
You have a SQL Server 2016 database named DB1.
You plan to import a large number of records from a SQL Azure database to DB1.
You need to recommend a solution to minimize the amount of space used in the transaction log during the import operation.
What should you include in the recommendation?
A. The bulk-logged recovery model
B. The full recovery model
C. A new partitioned table
D. A new log file
E. A new file group
Correct Answer: A
Explanation
Explanation/Reference:
Compared to the full recovery model, which fully logs all transactions, the bulk-logged recovery model minimally logs bulk operations, although fully logging other
transactions. The bulk-logged recovery model protects against media failure and, for bulk operations, provides the best performance and least log space usage.
Note:
The bulk-logged recovery model is a special-purpose recovery model that should be used only intermittently to improve the performance of certain large-scale bulk
operations, such as bulk imports of large amounts of data.
Reference: Recovery Models (SQL Server)