31.
Which of the following tools can you use to migrate Windows-authenticated SQL logins
from an x86 instance of SQL Server 2012 to an x64 instance of SQL Server 2012 if
contained databases are not in use? (Each correct answer presents a complete solution.
Choose all that apply.)
- A.Copy Database Wizard
- B.Import and Export Wizard
- C.Backup and Restore Database
- D.Generate A Script
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
|
A. Correct: You can use the Copy Database Wizard to migrate SQL logins from an
x86 instance of SQL Server 2012 to an x64 instance of SQL Server 2012; however,
this will also copy the entire database, not just the logins. B. Incorrect: You cannot use the Import and Export Wizard to copy logins from one SQL Server instance to another. C. Incorrect: Backing up and restoring a database does not copy login data because this is stored outside the database. Contained databases are the exception to this. D. Correct: You can use the Generate A Script option to create a script that enables you to re-create a Windows-authenticated SQL login on another instance. |
32.
You want to migrate a database, including logins and user-defined error messages,
from one SQL Server 2012 instance to another. Which of the following tools can you
use to accomplish this goal?
- A.Copy Database Wizard
- B.BACKUP DATABASE Transact-SQL statement
- C.Import and Export Wizard
- D.sp_detach_db stored procedure
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: You can use the Copy Database Wizard to migrate a database, including
logins and user-defined error messages, from one SQL Server 2012 instance to
another. B. Incorrect: You can use this statement to back up a database, but it will not back up logins and user-defined error messages, which are stored outside the database. C. Incorrect: You cannot use the Import and Export Wizard to migrate a database including logins and user-defined error messages. D. Incorrect: You use the sp_detach_db stored procedure to detach a database. You cannot use this stored procedure to migrate logins and user-defined error messages. |
33.
You want to use the detach and attach method of migrating a database to another
SQL Server 2012 Database Engine instance. The database is currently published and
replicated. Which of the following steps must you take prior to detaching the database
from the source instance? (Each correct answer presents part of a complete solution.
Choose all that apply.)
- A.Drop database snapshots
- B.Unpublish the database.
- C.Create a format file.
- D.Create a database snapshot
- Answer & Explanation
- Report
Answer : [A, B]
Explanation :
Explanation :
|
A. Correct: You must drop any database snapshots prior to detaching the database. B. Correct: You must unpublish the database from replication prior to detaching the database. C. Incorrect: Format files are used when performing bulk imports of data. You do not need to create a format file prior to detaching a database. D. Incorrect: You must remove database snapshots prior to detaching a database, not create additional snapshots. |
34.
You must create an XML format file based on a database table to use later when bulk
importing data on other instances. Which of the following tools would you use to
accomplish this goal?
- A.bcp utility
- B.Import and Export Wizard
- C.BULK INSERT statement
- D.OPENROWSET function
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: You use the bcp utility to create XML format files. These files are used
when importing files that use fixed-width fields. B. Incorrect: You cannot use the Import and Export Wizard to create an XML format file. You use the bcp utility to create this type of file. C. Incorrect: You cannot use the BULK INSERT statement to create an XML format file. You use the bcp utility to create this type of file. D. Incorrect: You cannot use the OPENROWSET function to create an XML format file. You use the bcp utility to create this type of file. |
35.
Which of the following tools can you use to create an Integration Services package that
enables you to repeat a specific data import or export operation?
- A.OPENROWSET function
- B.BULK INSERT statement
- C.Import and Export Wizard
- D.bcp utility
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: You cannot use the OPENROWSET function to save an export or import
configuration as an Integration Services package for later use. B. Incorrect: You cannot use the BULK INSERT statement to save an export or import configuration as an Integration Services package for later use. C. Correct: When you use the Import and Export Wizard to import or export data, you can save the import or export configuration as an Integration Services package that you can use later. D. Incorrect: You cannot use the bcp utility to save an export or import configuration as an Integration Services package for later use. |
|
|
||||||||||||||||||||||||||||
