MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
____________REPRESENTS_HOW_MANY_NETWORK_TRANSFERS_PER_SECOND_ARE_OCCURRING.?$ |
| A. | Network Bytes |
| B. | Network Transfers |
| C. | Memory reads |
| D. | None of the mentioned |
| Answer» C. Memory reads | |
| 2. |
What do you understand by design limitation in SSIS package ? |
| A. | Making use of parallelism |
| B. | Not making use of parallelism |
| C. | Package uses few single-threaded tasks |
| D. | None of the mentioned |
| Answer» C. Package uses few single-threaded tasks | |
| 3. |
The following Network perfmon counters can help you tune your topology ? |
| A. | Total Bandwidth |
| B. | Current Bandwidth |
| C. | Bandwidth bound |
| D. | All of the mentioned |
| Answer» C. Bandwidth bound | |
| 4. |
_________ represents to total memory pressure on the system in SSIS. |
| A. | Page sec |
| B. | Page Reads |
| C. | Memory reads |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
The key counters for Integration Services and SQL Server are : |
| A. | Process Bytes |
| B. | Public Bytes |
| C. | Private Set |
| D. | All of the mentioned |
| Answer» B. Public Bytes | |
| 6. |
If SSIS is not able to drive close to 100% CPU load, this may be indicative of: |
| A. | Software Contention |
| B. | Application contention |
| C. | Processor contention |
| D. | None of the mentioned |
| Answer» C. Processor contention | |
| 7. |
Which of the following is the best practice related to SSIS ? |
| A. | Plan for capacity by understanding resource utilization. |
| B. | SSIS is an in-memory pipeline, so ensure that all transformations occur in memory |
| C. | Baseline source system extract speed |
| D. | All of the mentioned |
| Answer» B. SSIS is an in-memory pipeline, so ensure that all transformations occur in memory | |
| 8. |
SSMS provides different options to develop your SSIS package starting with ___________ wizard. |
| A. | Import and Export |
| B. | Copy and Import |
| C. | Export and BulkInsert |
| D. | None of the mentioned |
| Answer» B. Copy and Import | |