You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when complex calculations are performed on large amounts of data under heavy system load.
You need to limit the number of cores that process the calculations.
What should you configure?

• A.Max worker threads
• B.Processor affinity
• C.I/O affinity
• D.Lightweight pooling

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user.
A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job.
The SSIS package accesses a network share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server.
You need to ensure that the SQL Server Agent job can execute the SSIS package.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

SQL Server Agent allows creating a proxy account which defines the security context for the job step.
We need to do is to create a credential to be used by the proxy account.
The created proxy need to have access to the SSIS subsystem
References: https://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server- agent-using-a-proxy-account/

Comment: *

Name: *

Email: *

Verification: *

You administer a Windows Azure SQL Database database used for data warehouse operations.
The database contains a table named OrdersHistory, defined as follows:

A weekly ETL (extract-transform-load) runs a large INSERT statement to add data into the OrdersHistory table. The process is taking a long time to complete. You discover that the bulk of the process is performing non-clustered index updates on the OrdersHistory table.
You need to improve the performance of the ETL process faster. You need to meet the following requirements:
Avoid losing existing permissions on existing objects.
Use minimal administrative effort.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

Which of the following conditions must exist prior to restoring a system database in SQL Server 2012?

• A.The hard drive must be reformatted.
• B.You must detach the user databases from the SQL 2012 instance.
• C.The SQL Server 2012 instance must be started in single-user mode.
• D.The SQL Server 2012 instance must be removed.

Comment: *

Name: *

Email: *

Verification: *

You administer a SQL Server 2012 database instance.
You need to configure the SQL Server Database Engine service on a failover cluster.
Which user account should you use?

• A.The BUILTIN\SYSTEM account
• B.A local user with Run as Service permissions
• C.TheSQLBrowser account
• D.A domain user

Comment: *

Name: *

Email: *

Verification: *