What is the drawback to using a linked server for integrating an external data source?
A) it enables a data source to be queried directly from within SQL Server
B) it enables a client application to efficiently perform bulk copy operations
C) it doesn't work well for dynamic data sources
D) you must configure it using the bcp utility
Correct Answer:
Verified
Q2: Which basic data integration tool provides step-by-step
Q3: Which of the following is NOT a
Q4: A package configuration file can be generated
Q5: What type of component should you use
Q6: ODBC is an API that is designed
Q7: Which of the following may be found
Q8: Configuring a linked server which enables a
Q9: Which type of SSIS package task permits
Q10: The BULK INSERT statement inserts records from
Q11: Which of the following is true about
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents