70-462 無料問題集「Microsoft Administering Microsoft SQL Server 2012/2014 Databases」
You administer a Microsoft SQL Server database server that has a database named Contoso. The Contoso database has a table named EmployeeSalary in a schema named HumanResources.
You need to create a script that writes audit events into the application log whenever data in the EmployeeSalary table is modified by the public principal.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)
You need to create a script that writes audit events into the application log whenever data in the EmployeeSalary table is modified by the public principal.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)
正解：
Explanation
References:
http://msdn.microsoft.com/en-us/library/cc280386.aspx
http://msdn.microsoft.com/en-us/library/cc280448.aspx
http://msdn.microsoft.com/en-us/library/cc280404.aspx
Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server server that hosts a transactional database and a reporting database.
The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:
At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database.
You need to ensure that the transactional database is restored.
You also need to ensure that data loss is minimal.
What should you do?
You administer a Microsoft SQL Server server that hosts a transactional database and a reporting database.
The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:
At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database.
You need to ensure that the transactional database is restored.
You also need to ensure that data loss is minimal.
What should you do?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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 Node A.
You want to patch both Node A and Node B by using the most recent SQL Server Service Pack.
You need to ensure that the following requirements are met:
* Both nodes receive the update.
* Downtime is minimized.
* No data is lost.
Which three 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.)
The instance is currently running on Node A.
You want to patch both Node A and Node B by using the most recent SQL Server Service Pack.
You need to ensure that the following requirements are met:
* Both nodes receive the update.
* Downtime is minimized.
* No data is lost.
Which three 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.)
正解：
Explanation
You are a database administrator for a Microsoft SQL Server 2012 database named AdventureWorks2012.
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
* Production transactions should be minimally affected.
* The secondary server should allow reporting queries to be performed.
* If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
* Production transactions should be minimally affected.
* The secondary server should allow reporting queries to be performed.
* If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have recently removed a SQL 2012 Database Engine instance from a computer running the Windows Server 2008 R2 operating system. Prior to the removal of the instance, you had configured affinity so that the default instance used CPU 0 and 1 and the second instance used CPU 2 and 3.
You want to ensure that the default instance can use all processors available to the host.
Which of the following commands would you use to accomplish this goal?
You want to ensure that the default instance can use all processors available to the host.
Which of the following commands would you use to accomplish this goal?
正解：A
解答を投票する
You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01.
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
Which three 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.)
You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring.
You need to prepare the Contoso database for database mirroring.
Which three 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.)
正解：
Explanation
References:
You administer a Microsoft SQL Server 2012 database.
The database contains a Product 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 Product table.
What should you do?
The database contains a Product 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 Product table.
What should you do?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You use Microsoft SQL Server 2012 to develop a database application. You create a stored procedure named dbo.ModifyData that can modify rows.
You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
* Does not return an error
* Closes all opened transactions
Which Transact-SQL statement should you use?
You need to ensure that when the transaction fails, dbo.ModifyData meets the following requirements:
* Does not return an error
* Closes all opened transactions
Which Transact-SQL statement should you use?
正解：C
解答を投票する
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 maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
正解：E
解答を投票する
You administer a Microsoft SQL Server database.
The database is in the Simple recovery mode.
You schedule the following backup plan:
* Full backup every day at midnight
* Differential backups every hour on the hour, except at midnight
The database fails at 20:45 hours.
You need to use SQL Server Management Studio (SSMS) to begin restoring the database with a minimum amount of data loss.
Which options should you select on the Options page of the Restore Database window? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
The database is in the Simple recovery mode.
You schedule the following backup plan:
* Full backup every day at midnight
* Differential backups every hour on the hour, except at midnight
The database fails at 20:45 hours.
You need to use SQL Server Management Studio (SSMS) to begin restoring the database with a minimum amount of data loss.
Which options should you select on the Options page of the Restore Database window? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
正解：
Explanation
First, restore full database backup, differential database backup and all transaction log backups WITH NORECOVERY Option. After that, bring back database online using WITH RECOVERY option.
References:
https://blog.sqlauthority.com/2009/07/15/sql-server-restore-sequence-and-understanding-norecovery-and-recove
A network administrator creates a virtual machine from a template that has SQL Server installed.
You need to ensure that you can create SQL Server databases on the new virtual machine.
Which two actions should you perform to complete the server configuration? Each correct answer presents part of the solution.
You need to ensure that you can create SQL Server databases on the new virtual machine.
Which two actions should you perform to complete the server configuration? Each correct answer presents part of the solution.
正解：A、D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)