The SQL Server _____ feature is an efficient means of copying data from a source database to your DB
Instance. It writes the data that you specify to a data file, such as an ASCII file.
A.
bulk copy
B.
group copy
C.
dual copy
D.
mass copy
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
A. Builk Copy
The SQL Server bulk copy feature is an efficient means of copying data from a source database to your DB instance. Bulk copy writes the data that you specify to a data file, such as an ASCII file. You can then run bulk copy again to write the contents of the file to the destination DB instance.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html
Also can use:
Native database backup using a full backup file (.bak) – Using .bak files to backup databases is heavily optimized, and is usually the fastest way to export data. For more information, see Importing and Exporting SQL Server Databases.
SQL Server Import and Export Wizard – For more information, see SQL Server Import and Export Wizard.
SQL Server Generate and Publish Scripts Wizard and bcp utility – For more information, see SQL Server Generate and Publish Scripts Wizard and bcp Utility.
0
0