- All Exams Instant Download
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use?A...
What should you create?
You administer a Microsoft SQL Server 2012 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?A . A Database Audit SpecificationB . A PolicyC...
What should you do?
You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node C has been added to the existing cluster. You need to ensure that the SQL...
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database. You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs. You also need to...
You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B
DRAG DROP You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B. The instance is currently running on NodeA . You want to patch both Node A and Node B by using the most recent SQL Server Service...
What should you do?
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment...
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database. You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs. You also need to...
What should you do?
You administer a Microsoft SQL Server 2012 database. The database contains a customer table created by using the following definition: You need to ensure that the minimum amount of disk space is used to store the data in the customer table. What should you do?A . Implement row-level compression.B ....
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 database. The database is backed up according to the following schedule: - Daily full backup at 23:00 hours. - Differential backups on the hour, except at 23:00 hours. - Log backups every 10 minutes from the hour, except on the hour....
Which backup option should you use?
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: - A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is...
