36.
You must copy the complete contents of a table in the Hovercraft database into a new
table in the Watercraft database. The destination table does not currently exist in the
Watercraft database. The Watercraft and Hovercraft databases are hosted on the same
SQL Server 2012 instance. Which of the following tools can you use to accomplish this
goal? (Each correct answer presents a complete solution. Choose all that apply.)
- A.bcp utility
- B.SELECT...INTO Transact-SQL statement.
- C.Import and Export Wizard
- D.Copy Database Wizard
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
|
A. Incorrect: Although the bcp utility can export the contents of an entire table and
then insert that data into another table, the destination table must already exist. B. Correct: You can use the SELECT...INTO Transact-SQL statement to copy the contents of one table to another table in a separate database on the same instance while having the destination table automatically created during the process. C. Correct: You can use the Import and Export Wizard to copy the contents of one table to another table in a separate database on the same instance while having the destination table automatically created during the process. D. Incorrect: Although you can use the Copy Database Wizard to copy an entire database, you cannot use this wizard to copy a single table. |
37.
You must connect to a remote OLE DB data source and import a substantial amount of
data into a table hosted on a local database. Which of the following tools can you use
to accomplish this goal? (Each correct answer presents a complete solution. Choose all
that apply.)
- A.Import and Export Wizard
- B.Copy Database Wizard
- C.bcp utility
- D.OPENROWSET(BULK) function
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
|
A. Correct: You can use the Import and Export Wizard to connect to a remote OLE
DB data source when you need to import a substantial amount of data. B. Incorrect: Although you can use the Copy Database Wizard to copy an entire SQL Server database, you do not use this tool to import data from an OLE DB data source. C. Incorrect: You can use the bcp utility only to import and export data from a local SQL Server instance. D. Correct: You can use the OPENROWSET(BULK) function as part of a statement that imports a substantial amount of data from a remote OLE DB data source. |
38.
You have a table that contains 20,000 customer records. Which of the following tools
can you use to export these records to a file? (Each correct answer presents a complete
solution. Choose all that apply.)
- A.bcp utility
- B.BULK INSERT Transact-SQL statement
- C.Import and Export Wizard
- D.Copy Database Wizard
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
|
A. Correct: You can use the bcp utility to perform a bulk export of data from a table
to a file. B. Incorrect: You can use the BULK INSERT Transact-SQL statement only to import data from a file. You cannot use this statement to export data to a file. C. Correct: You can use the Import and Export Wizard to export all the data hosted in a table to a file. D. Incorrect: You can use the Copy Database Wizard to copy a database from one instance to another. You cannot use this wizard to export data from a table to a file. |
39.
Which permission must a security principal have at the instance level to be able to create
SQL logins?
- A.ALTER ANY LOGIN
- B.ALTER ANY CREDENTIAL.
- C.ALTER ANY ENDPOINT
- D.ALTER SETTINGS
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
|
A. Correct: A security principal must have the ALTER ANY LOGIN permission to be
able to create SQL Server logins. B. Incorrect: The ALTER ANY CREDENTIAL permission allows for the creation of credentials rather than logins. C. Incorrect: The ALTER ANY ENDPOINT permission allows for the creation of endpoints rather than logins. D. Incorrect: The ALTER SETTINGS permission allows for the modification of Database Engine settings rather than creation of SQL Server logins. |
40.
You are managing a SQL Server 2012 instance installed on a server named SQL-SYD.
You want to create a SQL Server login that is mapped to the Research security group in
the CONTOSO domain. Which of the following statements would you use to accomplish
this goal?
- A.CREATE LOGIN [Research] WITH PASSWORD = ‘Pa$$w0rd’
- B.CREATE USER [Research] WITH PASSWORD = ‘Pa$$word’
- C.CREATE LOGIN “CONTOSO\Research” FROM WINDOWS
- D.CREATE USER “CONTOSO\Research”
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
|
A. Incorrect: The CREATE LOGIN [Research] WITH PASSWORD = ‘Pa$$w0rd’ statement
creates a SQL-authenticated login rather than one mapped to a domain
security group. B. Incorrect: You would use the CREATE USER [Research] WITH PASSWORD = ‘Pa$$w0rd’ statement to create a contained user rather than a SQL Server login. C. Correct: You use the CREATE LOGIN “CONTOSO\Research” FROM WINDOWS statement to create a SQL Server login that is mapped to the Research security group in the CONTOSO domain. D. Incorrect: You would use the CREATE USER “Contoso\Research” statement to create a contained database user who uses the Research security group in the Contoso domain. This will not create a login that uses this security group at the database-instance level. |
|
|
||||||||||||||||||||||||||||
