Term
A(n) ____ is an executable program used to move data into and out of SQL Server 2000?
A) BULK INSERT program
B) BULK INSERT statement
C) BULK COPY program
D) All Of The Above |
|
Definition
|
|
Term
Which of the following is a statement used in SQL Server 2000 to insert data into a table or view from a data file?
A) BULK COPY
B) BULK INSERT
C) DATA LATENCY
D) DATA TRANSFORMATION |
|
Definition
|
|
Term
Which of the following executes a BULK INSERT?
A) Data transformation service
B) BULK INSERT statement
C) BULK COPY Program
D) DTS Designer |
|
Definition
|
|
Term
Which of the following is the measure of how long it takes after data modifications are made on one server before they are reflected on a server to which the data is replicated?
A) Data Transformation
B) Data Distribution
C) Data Latency
D) Data Publication |
|
Definition
|
|
Term
Which of the following is a bundled set of features for importing, exporting, and transforming data using a variety of data formats and transfer mappings?
A) Data Transformation Services
B) Data Latency Services
C) Data Insert Services
D) Data Copy Services |
|
Definition
| A) Data Transformation Services |
|
|
Term
Which of the following is a tool available in Enterprise Manager that allows the creation and design of DTS packages?
A) DTS Publisher
B) DTS Merger
C) DTS Designer
D) All Of The Above |
|
Definition
|
|
Term
Which of the following is a set of DTS tasks that each move or transform data or perform related tasks?
A) DTS Package
B) DTS Merge Package
C) DTS Replication
D) None Of The Above |
|
Definition
|
|
Term
Which of the following is a server that participates in replication by moving data to subscribers?
A) Designer
B) Publisher
C) Packager
D) Distributor |
|
Definition
|
|
Term
Which of the following types of replication allows changes made at different sites to be assimilated at a later time?
A) Merge Replication
B) Compression Replication
C) Subscription Replication
D) All Of The Above |
|
Definition
|
|
Term
Which of the following is a server that participates in replication by creating a set of articles?
A) Subscriber
B) Publisher
C) Transcriber
D) DTS Designer |
|
Definition
|
|
Term
____ is the process of synchronizing copies of data stored in multiple sites.
A) Snapshot Replication
B) Merge Replication
C) Replication
D) Distribution |
|
Definition
|
|
Term
Which of the following types of replication periodically copies entire publications as they exist at a moment in time?
A) Merge Replication
B) Snapshot Replication
C) Virtual Replication
D) Design Replication |
|
Definition
|
|
Term
Which of the following are namespaces that do NOT correspond to physical file folders that are tracked by IIS so that requests can be forwarded to SQL Server 2000?
A) SQL Virtual Names
B) SQL Virtual Replication
C) SQL Virtual Subscriptions
D) SQL Virtual Directories |
|
Definition
| D SQL Virtual Directories |
|
|
Term
Which of the following are considered sub-namespaces in IIS whose http requests are forwarded to SQL Server 2000 as a specific type of request?
A) SQL Virtual Directories
B) SQL Virtual Names
C) SQL Virtual Subscriptions
D) None Of The Above |
|
Definition
|
|
Term
Which of the following is an implementation of the Internet Services API (ISAPI) filter that provides SQL specific functionality to Internet Information Services?
A)sqlisapi.dll
B)sqlisapi.dat
C)sqlisapi.sys
D)sqlis.ip.exe |
|
Definition
|
|
Term
Which of the following is a server that participates in replication by subscribing to publications?
A) Distributor
B) Transactional Publisher
C) Merging Publisher
D) Subscriber |
|
Definition
|
|
Term
Which of the following types of replication involve incremental changes made on the publisher which are sent to each subscriber?
A) Snapshot Replication
B) Transactional Replication
C) Merge Replication
D) Distribution Replication |
|
Definition
| B) Transactional replication |
|
|
Term
Which of the following is the syntax used to query an XML document based on naming the element whose data is desired?
A) YPath
B) NPath
C) XPath
D) All The Above |
|
Definition
|
|
Term
In order to optimize the performance of a BULK INSERT, it is possible to cause SQL Server 2000 NOT to log the inserts of the records. Which of the following must be true in order for that to occur?
A) The database option select into \bulkcopy
B) The target table has NO indexes or if the table has NO indexes it is emptied
C) The target table is NOT to be replicated
D) All Of The Above |
|
Definition
|
|
Term
Because the BCP utility is invoked outside of SQL Server 2000, you must specify a server and user context in which the action is to be executed using which of the following parameters?
A) -s server_name
B) -u login_id
C) -P password
D) Both B and C |
|
Definition
|
|
