1.) Which migration method(s) can be used to copy complete databases to a compressed (zipped) file.

Group of answer choices

Both Export a Data Tier Application and Generate a Script

Export a Data Tier Application

DTS

Generate a Script

2.)

Which method produces a backup of a complete database zipped.

Group of answer choices

Generate a Script

Export a Data Tier Application

DTS

3.)

Which method produces a series of SQL commands including CREATE TABLE and Insert statements.

Group of answer choices

DTS

Generate a Script

Export a Data Tier Application

4.)

Does not migrate Primary Keys and Identity columns along with the remaining schema and data.

Group of answer choices

Export a Data Tier Application

DTS

Generate a Script

5.)

Which two methods could be used to copy SQL Server data to a non-SQL Server DBMS with little or no change?

Group of answer choices

Export a Data Tier App & Generate a Script

DTS & Generate a Script

DTS & Export a Data Tier App

6.)

Upsizing is a form of Data Migration

Group of answer choices

True

False

7.)

All three methods demonstrated allowed specific or all tables to be migrated.

Group of answer choices

True

False

8.)

Which method would I use to import an Excel Spreadsheet into a Oracle database?

Group of answer choices

Export a Data Tier Application

All of these

DTS

Generate a Script