gs gs116 Data Connectivity - SQL Server Integration Services - Quiz No.2

gs gs116 Microsoft SQL Server Quiz

This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Connectivity. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.

NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.

Question 1: Which of the following will increase the Rows/sec calculation in SSIS?

Improve drivers and driver configurations

Start single connections

Use single NIC cards

None of the mentioned

Question 2: 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

Question 3: 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

Question 4: 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

Question 5: 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

NVAEducation

gs gs116 Data Connectivity - SQL Server Integration Services - Quiz No.2

gs gs116 Microsoft SQL Server Quiz

Online Quizzes of gs116 Microsoft SQL Server

Other DB related online quizzes

Other categories of gs Online Quizzes

Other organizations

Virtual University

Gegasoft

Theme Customizer