You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica.You have multiple queries that read data and produce reports from the database.You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica.What should you do?
You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain.You plan to configure database mirroring.You need to be able to create database mirroring endpoints on both servers.What should you do?
You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.When SQL Server Agent jobs fail, the error messages returned by the job steps do not provide the required detail.The following error message is an example error message:"The job failed. The Job was invoked by User CONTOSO\ServiceAccount. The last step to run was step 1 (Subplan_1)."You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained.What should you do?
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.)Select and Place:
You administer a Microsoft SQL Server instance.You need to configure a new database to support FILETABLES.Which three actions should you perform? Each correct answer presents part of the solution.
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.You administer all the deployments of Microsoft SQL Server in your company.You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.You also need to minimize the amount of storage used by the database.Which configuration should you use?
