Microsoft Administering a SQL Database Infrastructure Set 3

You administer a single server that contains a Microsoft SQL Server 2016 default instance.
You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions.
You need to ensure that the application login is unable to access other production databases.
What should you do?

You administer a Microsoft SQL Server 2016 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?

You administer a Microsoft SQL Server 2016 instance. The instance contains a database that supports a retail sales application.
The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the
database.
You need to ensure that the following requirements are met:
No more than 5 minutes worth of transactions are lost.

Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose all that apply.

You administer a Microsoft SQL Server 2016 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered
index is fragmented.
You need to reduce fragmentation.
You need to achieve this goal without taking the index offline.
Which Transact-SQL batch should you use?

You administer a Microsoft SQL Server database named Sales.
The database is 3 terabytes in size.
The Sales database is configured as shown in the following table.
You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?

You administer a Microsoft SQL Server 2016 server.
You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.
You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01.
What should you create?

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.
You need to be notified immediately when fatal errors occur on Server01.
What should you create?

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.
You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server.
What should you create?

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.
You need to prevent users from disabling server audits in Server01.
What should you create?