Welcome to the Data Connectivity MCQs Page

Dive deep into the fascinating world of Data Connectivity with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Data Connectivity, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Data Connectivity, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

Check out the MCQs below to embark on an enriching journey through Data Connectivity. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Data Connectivity. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Data Connectivity MCQs | Page 9 of 10

Explore more Topics under SQL Server

01

SQL Server Basics

02

Data Modification and Constraints

03

Beyond Relational

04

Data Definition Language

05

Development with SQL Server

06

Enterprise Data Management

07

Data Security

08

Monitoring and Auditing

09

Performance Tuning and Optimization

10

Business Intelligence and Reporting Services

Q81.

Point out the correct statement.

If the network is your bottleneck, then a potential solution is to use a single NIC card per server

To overcome the limitations of drivers, you can try to start multiple connections to your data source

For 64-bit systems, at design time you may be loading 32-bit drivers; ensure that at run time you are using 32-bit drivers

None of the mentioned

Discuss

Answer: (b).To overcome the limitations of drivers, you can try to start multiple connections to your data source

Q82.

When you execute SQL statements within Integration Services, the following optimization can be made?

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

In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache

If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing

All of the mentioned

Discuss

Answer: (b).In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache

Q83.

Which of the following steps should be carried out using data types in SSIS for efficient results?

Make data types as wide as possible so you will allocate more memory for your transformation

Do not perform excessive casting of data types

Do not watch precision issues when using the money, float, and decimal types

None of the mentioned

Discuss

Answer: (b).Do not perform excessive casting of data types

Q84.

Point out the wrong statement.

Heap inserts are typically slower than using a clustered index

Use partitions and partition SWITCH command; i.e., load a work table that contains a single partition and SWITCH it into the main table after you build the indexes and put the constraints on

Use the NOLOCK or TABLOCK hints to remove locking overhead

Use a commit size of <5000 to avoid lock escalation when inserting; note that in SQL Server 2008 you can now enable/disable lock escalation at the object level, but use this wisely

Discuss

Answer: (a).Heap inserts are typically slower than using a clustered index

Q85.

Which of the following error message indicates that the package cannot run in SSIS?

DTS_E_CANTINSERTCOLUMNTYPE

DTS_E_CACHELOADEDFROMFILE

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN

DTS_E_CONNECTIONREQUIREDFORMETADATA

Discuss

Answer: (a).DTS_E_CANTINSERTCOLUMNTYPE

Q86.

Which of the following is the event logged by the Integration Services?

SQLISService_255

SQLISService_256

SQLISService_155

SQLISService_156

Discuss

Answer: (b).SQLISService_256

Q87.

Purpose of SQLISPackage_12546 event in SQLIS package is to _____________

Indicate that a package started

Indicate that a task or other executable in a package has finished its work

Indicate that a warning message was raised in a package

All of the mentioned

Discuss

Answer: (b).Indicate that a task or other executable in a package has finished its work

Q88.

A basic package in SSIS includes the following elements?

T-SQL flow elements

Control flow elements

DataSet flow statements

None of the mentioned

Discuss

Answer: (b).Control flow elements

Q89.

Which of the following evaluation operation is provided in SSIS?

A constraint that uses only the execution result of the precedence executable to determine whether the constrained executable runs

An expression that is evaluated to determine whether the constrained executable runs

An expression and a constraint that combines the requirements of execution results of the precedence executable

All of the mentioned

Discuss

Answer: (d).All of the mentioned

Q90.

The __________ is an Access add-in program that provides data analysis tools for financial analysis.

Analysis ToolPak

Analysis Tool

Analysis ToolSQL

All of the mentioned

Discuss

Answer: (a).Analysis ToolPak

Page 9 of 10

Welcome to the Data Connectivity MCQs Page

Data Connectivity MCQs | Page 9 of 10

Explore more Topics under SQL Server

SQL Server Basics

Data Modification and Constraints

Beyond Relational

Data Definition Language

Development with SQL Server

Enterprise Data Management

Data Security

Monitoring and Auditing

Performance Tuning and Optimization

Business Intelligence and Reporting Services

Suggested Topics

Digital Image Processing (DIP)

Management Information Systems

Cyber Security

Digital Logic Design

Visual Basic

PHP

R Programming

Data Science

DBMS