Shop

banner-platium-04

QUESTION 7
You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2016 to Server1. Each instance will have multiple databases.
You need to recommend a method to allocate processor time to each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.A. Resource Governor
B. Max Degree of Parallelism
C. Windows System Resource Manager (WSRM)
D. Processor affinity
Correct Answer: A
Explanation
Explanation/Reference:
SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables
you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use.
Reference: Resource Governor
Incorrect:
D: PROCESS AFFINITY
Enables hardware threads to be associated with CPUs

CV0-001 dumps

QUESTION 8
You deploy a database by using SQL Server 2016. The database contains a table named Table1.
You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.
What should you recommend?
A. Change data capture
B. Statistics
C. A trigger
D. Master Data Services
Correct Answer: A
Explanation
Explanation/Reference:
Change data capture is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an
easily consumed relational format. The change tables used by change data capture contain columns that mirror the column structure of a tracked source table,
along with the metadata needed to understand the changes that have occurred.
Reference: About Change Data Capture (SQL Server)

nanolove02

Hiển thị tất cả 13 kết quả