MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following evaluation operation is provided in SSIS? |
| A. | A constraint that uses only the execution result of the precedence executable to determine whether the constrained executable runs |
| B. | An expression that is evaluated to determine whether the constrained executable runs |
| C. | An expression and a constraint that combines the requirements of execution results of the precedence executable |
| D. | All of the mentioned |
| Answer» E. | |
| 2. |
A basic package in SSIS includes the following elements? |
| A. | T-SQL flow elements |
| B. | Control flow elements |
| C. | DataSet flow statements |
| D. | None of the mentioned |
| Answer» C. DataSet flow statements | |
| 3. |
Which of the following error message indicates that the package cannot run in SSIS? |
| A. | DTS_E_CANTINSERTCOLUMNTYPE |
| B. | DTS_E_CACHELOADEDFROMFILE |
| C. | DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN |
| D. | DTS_E_CONNECTIONREQUIREDFORMETADATA |
| Answer» B. DTS_E_CACHELOADEDFROMFILE | |
| 4. |
When you execute SQL statements within Integration Services, the following optimization can be made? |
| A. | If Integration Services and SQL Server run on the different server, use the SQL Server destination instead of the OLE DB destination to improve performance |
| B. | In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache |
| C. | If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing |
| D. | All of the mentioned |
| Answer» C. If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing | |