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 mentionedI got this question in an online quiz.I'm obligated to ask this question of Integration Services in section Data Connectivity of SQL Server

When you execute SQL statements within Integration Services, the follo

1.	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 mentionedI got this question in an online quiz.I'm obligated to ask this question of Integration Services in section Data Connectivity of SQL Server
Answer» Correct answer is (B) In SQL Server 2008 INTEGRATION SERVICES, there is a new feature of the shared lookup cache To explain: When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache.

Discussion

No Comment Found

Related InterviewSolutions

_________ shows information about Access databases that have been added to the project.(a) SQL Server Metadata Explorer(b) Access Metadata Explorer(c) Access Metadata Expl(d) None of the mentionedI got this question in class test.This key question is from Access With Sql Server in portion Data Connectivity of SQL Server
Which of the following change took place in JULY 2014 release of SSMA?(a) Added support of MS SQL Server 2014(b) Set cascade actions for circular references to No Action(c) Fixed bugs regarding invisible report pages in IE 10(d) Highlighting of “well known” LOB schemasThis question was addressed to me at a job interview.My question is taken from Access With Sql Server topic in portion Data Connectivity of SQL Server
Which of the following option is used to find database objects by using filter criteria?(a) Advanced Object Select dialog box(b) Advanced find Select dialog box(c) Advanced filter Select dialog box(d) Advanced Object and filter Select dialog boxThis question was addressed to me in an internship interview.My doubt is from Access With Sql Server topic in section Data Connectivity of SQL Server
Which is the most serious issue after migration of access database to SQL Server?(a) Auto-increment columns are not updated until the record is updated(b) Slow performance with linked tables(c) New records are not available(d) You cannot modify a linked table schema with AccessThis question was posed to me during a job interview.I would like to ask this question from Access With Sql Server topic in portion Data Connectivity of SQL Server
Point out the wrong statement.(a) SQL Server Migration Assistant is an environment that helps you quickly migrate Access databases to SQL Server or SQL Azure(b) By using SSMA, you can review Access and SQL Server or SQL Azure database objects(c) When you link an Access table to a SQL Server, SQL Server database engine stores connection information and table metadata(d) None of the mentionedThis question was posed to me during an interview.I would like to ask this question from Access With Sql Server in section Data Connectivity of SQL Server
__________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005.(a) SSAM(b) SSMA(c) SSMS(d) SSASI got this question during an interview.The question is from Access With Sql Server in division Data Connectivity of SQL Server
When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.(a) link(b) unlink(c) import(d) all of the mentionedThis question was posed to me in my homework.The origin of the question is Access With Sql Server in portion Data Connectivity of SQL Server
Point out the correct statement.(a) SSMS for Access converts Access database objects to SQL Server or SQL Azure database object(b) Use the CONVERSION page of the Project Settings dialog box to specify how much data appears on the Data tab(c) SSMA for Access converts Access database objects to SQL Server or SQL Azure database object(d) None of the mentionedI have been asked this question at a job interview.This question is from Access With Sql Server in portion Data Connectivity of SQL Server
The __________ is an Access add-in program that provides data analysis tools for financial analysis.(a) Analysis ToolPak(b) Analysis Tool(c) Analysis ToolSQL(d) All of the mentionedI had been asked this question during a job interview.My enquiry is from Access With Sql Server in portion Data Connectivity of SQL Server
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 mentionedThis question was posed to me in an online interview.The question is from Integration Services topic in section Data Connectivity of SQL Server

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment