最新的Microsoft Administering Microsoft SQL Server 2012/2014 Databases - 70-462免費考試真題
問題1
You administer a Microsoft Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?
正確答案: B
問題2
You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly.
You discover that a large amount of memory is consumed by single-use dynamic queries.
You need to reduce procedure cache usage from these statements without creating any additional indexes.
What should you do?
You discover that a large amount of memory is consumed by single-use dynamic queries.
You need to reduce procedure cache usage from these statements without creating any additional indexes.
What should you do?
正確答案: K
問題3
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 a SQL Server database server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that UserA is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?
You administer a SQL Server database server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that UserA is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?
正確答案: E
問題4
You administer a Microsoft SQL Server database.
The database contains a table that has the following definition:
You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
* The first row of the file contains the first row of data.
* Each record is of the same length.
* The date follows the U.S. date format.
* The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
The database contains a table that has the following definition:
You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
* The first row of the file contains the first row of data.
* Each record is of the same length.
* The date follows the U.S. date format.
* The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
正確答案:
Explanation
References:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx
問題5
You administer a Microsoft SQL Server 2012 database named Human_Resources.
You need to ensure that all read activity against any object in the Human_Resources database is audited and written to a text file.
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.)
You need to ensure that all read activity against any object in the Human_Resources database is audited and written to a text file.
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.)
正確答案:
Explanation
Create a new Audit. For destination, select File.
Create a new Database Audit Specification on Human_Resources. For Audit Action Type, select Select, and for Object Class, select Database.
Enable Audi and Audi Specification.
The general process for creating and using an audit is as follows.
References:
https://msdn.microsoft.com/en-us/library/cc280386%28v=sql.110%29.aspx
https://msdn.microsoft.com/en-us/library/cc280663%28v=sql.110%29.aspx
問題6
You want to add a new GUID column named BookGUID to a table named dbo.Book that already contains data.
BookGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.Book. You need to ensure that the new column is assigned a GUID for existing rows. Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
BookGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.Book. You need to ensure that the new column is assigned a GUID for existing rows. Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
正確答案:
Explanation
References:
問題7
Which of the following SQL Server 2012 tools assists DBAs in running and analyzing trace results?
正確答案: B
說明：（僅 VCESoft 成員可見）
問題8
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
說明：（僅 VCESoft 成員可見）
問題9
Which of the following recovery models must be in use for point-in-time recovery to be possible for an SQL Server 2012 database?
正確答案: B
說明：（僅 VCESoft 成員可見）
問題10
You administer a Microsoft SQL Server 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 located on a dedicated LUN (drive E).
*Drive D has 1 terabyte of free disk space.
*Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between
09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and
15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
The financial database has been damaged.
You need to perform a tail-log backup.
Which backup option should you use?
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 located on a dedicated LUN (drive E).
*Drive D has 1 terabyte of free disk space.
*Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between
09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and
15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
The financial database has been damaged.
You need to perform a tail-log backup.
Which backup option should you use?
正確答案: M
問題11
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012.
The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application.
You need to migrate the database without affecting the production environment.
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 development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application.
You need to migrate the database without affecting the production environment.
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:
