62 + Interview Questions in Data Connectivity in SQL Server Page 1 InterviewSolution

1.	_________ 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
Answer» RIGHT answer is (b) Access METADATA Explorer Easiest explanation: SSMA contains two metadata explorers to browse and perform ACTIONS on Access and SQL SERVER or Azure SQL DB databases.

Discussion

2.	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
Answer» The CORRECT option is (d) HIGHLIGHTING of “WELL known” LOB schemas For explanation: This change was done so that they can be IGNORED in conversion.

Discussion

3.	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
Answer» Correct option is (a) Advanced Object SELECT dialog box For explanation: Advanced Object Select dialog box FIRST USES filter criteria to search for objects.

Discussion

4.	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
Answer» RIGHT ANSWER is (B) Slow performance with linked tables The EXPLANATION is: Some QUERIES might be slow after upsizing.

Discussion

5.	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
Answer» RIGHT choice is (c) When you LINK an Access table to a SQL Server, SQL Server database engine stores CONNECTION INFORMATION and table metadata The explanation is: Jet database engine stores connection information and table metadata.

Discussion

6.	__________ 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
Answer» The correct option is (b) SSMA Explanation: SSMA STANDS for Microsoft SQL SERVER Migration Assistant for ACCESS.

Discussion

7.	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
Answer» Correct OPTION is (b) unlink Explanation: If you have linked the Access tables to ONE SQL SERVER INSTANCE, and then you want to change the links to ANOTHER instance, you must relink the tables.

Discussion

8.	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
Answer» Correct choice is (C) SSMA for Access converts Access database objects to SQL SERVER or SQL Azure database object For EXPLANATION I would say: SSMA LOADS those objects into SQL Server or SQL Azure, and then migrates data from Access to SQL Server or SQL Azure.

Discussion

9.	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
Answer» Correct OPTION is (a) Analysis ToolPak Explanation: Analysis ToolPak is used for COMPLEX, statistical analyses.

Discussion

10.	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
Answer» RIGHT answer is (B) Control FLOW elements Easy explanation: Control flow elements perform various functions, PROVIDE structure and control the order in which elements run.

Discussion

11.	Purpose of SQLISPackage_12546 event in SQLIS package is to _____________(a) Indicate that a package started(b) Indicate that a task or other executable in a package has finished its work(c) Indicate that a warning message was raised in a package(d) All of the mentionedThe question was asked in an interview for internship.This intriguing question comes from Integration Services topic in portion Data Connectivity of SQL Server
Answer» Correct option is (b) INDICATE that a TASK or other executable in a PACKAGE has FINISHED its work For explanation I would SAY: SQLISPackage_12288 indicates that a package started.

Discussion

12.	Which of the following is the event logged by the Integration Services?(a) SQLISService_255(b) SQLISService_256(c) SQLISService_155(d) SQLISService_156This question was posed to me during an interview.I would like to ask this question from Integration Services topic in chapter Data Connectivity of SQL Server
Answer» RIGHT option is (b) SQLISService_256 The EXPLANATION is: SQLISService_256 event indicates that the SERVICE is about to start.

Discussion

13.	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_CONNECTIONREQUIREDFORMETADATAI have been asked this question at a job interview.My question comes from Integration Services topic in chapter Data Connectivity of SQL Server
Answer» CORRECT OPTION is (a) DTS_E_CANTINSERTCOLUMNTYPE The explanation is: Cache Transform TRANSFORMATION is trying to WRITE data to the in-memory cache.

Discussion

14.	Which of the following steps should be carried out using data types in SSIS for efficient results?(a) Make data types as wide as possible so you will allocate more memory for your transformation(b) Do not perform excessive casting of data types(c) Do not watch precision issues when using the money, float, and decimal types(d) None of the mentionedThis question was posed to me during an online interview.I'm obligated to ask this question of Integration Services topic in section Data Connectivity of SQL Server
Answer» Right OPTION is (b) Do not PERFORM excessive casting of data types The explanation: Excessive casting of data types it will only degrade performance. MATCH your data types to the source or destination and explicitly specify the NECESSARY data type casting.

Discussion

15.	Point out the wrong statement.(a) Heap inserts are typically slower than using a clustered index(b) 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(c) Use the NOLOCK or TABLOCK hints to remove locking overhead(d) Use a commit size of
Answer» Right answer is (a) Heap inserts are typically slower than using a clustered index For EXPLANATION I would say: For using Heap inserts, you may WANT to drop INDEXES and rebuild if you are changing a LARGE part of the DESTINATION table; you will want to test your inserts both by keeping indexes in place and by dropping all indexes and rebuilding to validate.

Discussion

16.	Point out the correct statement.(a) If the network is your bottleneck, then a potential solution is to use a single NIC card per server(b) To overcome the limitations of drivers, you can try to start multiple connections to your data source(c) 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(d) None of the mentionedI have been asked this question during a job interview.I need to ask this question from Integration Services topic in chapter Data Connectivity of SQL Server
Answer» The CORRECT ANSWER is (b) To OVERCOME the limitations of drivers, you can try to start multiple connections to your DATA source For explanation I would say: As LONG as the source can handle many concurrent connections, you may see an increase in throughput if you start several extracts at once.

Discussion

17.	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

18.	Which of the following will increase the Rows/sec calculation in SSIS?(a) Improve drivers and driver configurations(b) Start single connections(c) Use single NIC cards(d) None of the mentionedThe question was asked in a job interview.The above asked question is from Integration Services topic in section Data Connectivity of SQL Server
Answer» Right CHOICE is (a) Improve drivers and driver configurations Best explanation: Make SURE you are USING the most up-to-date driver configurations for your NETWORK, DATA source, and disk I/O.

Discussion

19.	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 mentionedThis question was addressed to me in exam.Asked question is from Integration Services in section Data Connectivity of SQL Server
Answer» Correct answer is (B) Not MAKING USE of PARALLELISM For explanation: The DESIGN limitation of SSIS package is not making use of parallelism.

Discussion

20.	The following Network perfom counters can help you tune your topology?(a) Total Bandwidth(b) Current Bandwidth(c) Bandwidth bound(d) All of the mentionedThe question was posed to me in unit test.I'm obligated to ask this question of Integration Services in section Data Connectivity of SQL Server
Answer» The correct CHOICE is (B) Current Bandwidth The BEST I can EXPLAIN: Current Bandwidth counter provides an estimate of current bandwidth.

Discussion

21.	_________ represents to total memory pressure on the system in SSIS.(a) Page sec(b) Page Reads(c) Memory reads(d) All of the mentionedI got this question in an international level competition.My doubt stems from Integration Services in division Data Connectivity of SQL Server
Answer» Correct choice is (d) All of the mentioned The explanation is: If PAGE reads consistently GOES above 500, the SYSTEM is under memory PRESSURE.

Discussion

22.	Point out the wrong statement.(a) SSIS moves data as fast as your network is able to handle it(b) It is important to understand your network topology and ensure that the path between your source and target have both low latency and high throughput(c) Integration Services can be tuned beyond the speed of your source(d) All of the mentionedI have been asked this question in class test.I want to ask this question from Integration Services in chapter Data Connectivity of SQL Server
Answer» Right option is (c) Integration SERVICES can be tuned beyond the SPEED of your source The best I can explain: You cannot TRANSFORM data FASTER than you can read it in SSIS.

Discussion

23.	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 mentionedThis question was addressed to me in a job interview.My question comes from Integration Services in section Data Connectivity of SQL Server
Answer» RIGHT option is (B) Application contention The BEST I can explain: In Application contention, SQL Server is taking on more processor resources, MAKING them UNAVAILABLE to SSIS.

Discussion

24.	The key counters for Integration Services and SQL Server are _______________(a) Process Bytes(b) Public Bytes(c) Private Set(d) All of the mentionedThis question was posed to me in an online quiz.My question is based upon Integration Services topic in section Data Connectivity of SQL Server
Answer» CORRECT ANSWER is (a) PROCESS Bytes To explain: Process byte is the AMOUNT of memory currently in use by Integration Services. This memory cannot be shared with other processes.

Discussion

25.	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 mentionedThe question was posed to me by my school principal while I was bunking the class.My enquiry is from Integration Services in division Data Connectivity of SQL Server
Answer» The correct answer is (a) PLAN for capacity by understanding resource utilization For explanation I would say: SQL Server Integration Services is designed to process large AMOUNTS of DATA row by row in memory with high speed. Because of this, it is important to understand resource utilization, i.e., the CPU, memory, I/O, and NETWORK utilization of your packages.

Discussion

26.	Point out the wrong statement.(a) Prior to SSIS, Data Transformation Services (DTS) in SQL Server 2000 performs the tasks with fewer features(b) SSIS is used to perform operations like loading the data based on the need, performing different transformations on the data like doing calculations(c) Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages(d) All of the mentionedThis question was addressed to me in examination.The query is from Integration Services topic in division Data Connectivity of SQL Server
Answer» Right answer is (C) Business Intelligence Development Studio (BIDS) is a tool which can be used to DEVELOP only SSIS packages To EXPLAIN: BIDS is available with SQL SERVER as an interface that provides the developers to work on the workflow of the PROCESS that can be made step by step.

Discussion

27.	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 mentionedI had been asked this question during a job interview.The origin of the question is Integration Services topic in chapter Data Connectivity of SQL Server
Answer» The correct OPTION is (a) Import and Export The explanation is: With SSIS wizards, we can create a STRUCTURE on how the DATA flow should happen and make a package and deploy it BASED on our NEEDS to execute in any environment.

Discussion

28.	Two types of subscriptions present for replication is _____________(a) push and pull(b) throw and pull(c) push and throw(d) none of the mentionedI got this question during an online exam.Origin of the question is Replication in portion Data Connectivity of SQL Server
Answer» The correct OPTION is (a) push and pull The best I can EXPLAIN: Push SUBSCRIPTIONS are created at the PUBLISHER server and pull subscriptions INITIATES the replication instead of the publisher.

Discussion

29.	Which of the following makes data available for replication?(a) Article(b) Publisher(c) Distributor(d) SubscriptionThe question was asked in an interview for internship.The query is from Replication topic in chapter Data Connectivity of SQL Server
Answer» The correct ANSWER is (B) Publisher The best I can EXPLAIN: Publisher is a SOURCE database where replication starts.

Discussion

30.	How many types of replication components are present in SQL Server?(a) 6(b) 7(c) 8(d) 9This question was addressed to me in a national level competition.My enquiry is from Replication topic in portion Data Connectivity of SQL Server
Answer» Right answer is (c) 8 Easy explanation: SQL SERVER REPLICATION is based on the “PUBLISH and Subscribe” metaphor.

Discussion

31.	Which of the following stored procedure provide replication support for AlwaysOn?(a) sp_validate_replica_publishers(b) sp_validate_hosts_as_publishers(c) sp_validate_replica_hosts_as_publishers(d) all of the mentionedI had been asked this question in quiz.This question is from Replication topic in division Data Connectivity of SQL Server
Answer» Right ANSWER is (C) sp_validate_replica_hosts_as_publishers To explain I would say: Four new stored procedures provide replication SUPPORT for ALWAYSON.

Discussion

32.	Which of the following is a disadvantage of replication?(a) Improved performance(b) To move data closer to the user(c) Easy maintenance(d) None of the mentionedI have been asked this question in an internship interview.The origin of the question is Replication topic in section Data Connectivity of SQL Server
Answer» The correct CHOICE is (d) None of the mentioned The EXPLANATION is: In SQL Server 2005, replication had to be stopped in order to perform some actions like ADDING nodes, making schema changes, ETC. But in 2008, these can be done online.

Discussion

33.	Point out the wrong statement.(a) Log shipping and mirroring allows to maintain complete database redundancy(b) Replication allows to maintain some part of the database (a set of required objects) at users location(c) Replication is object level low availability feature(d) All of the mentionedI had been asked this question in quiz.Origin of the question is Replication topic in chapter Data Connectivity of SQL Server
Answer» RIGHT choice is (c) Replication is object level low availability feature The explanation is: Replicate doesn’t DISTRIBUTE entire database, but only distributes some part of database LIKE tables or VIEWS ensuring HIGH availability feature.

Discussion

34.	Replication in SQL Server is used to overcome ________________(a) Performance problems(b) Availability problems(c) Maintenance problems(d) All of the mentionedThis question was addressed to me in final exam.My doubt is from Replication topic in division Data Connectivity of SQL Server
Answer» Correct answer is (d) All of the mentioned Explanation: Replication allows US to MAINTAIN the same DATABASE multiple copies at different locations.

Discussion

35.	How many types of replication is provided by SQL Server?(a) 2(b) 3(c) 4(d) 5This question was addressed to me in semester exam.The doubt is from Replication topic in division Data Connectivity of SQL Server
Answer» CORRECT ANSWER is (b) 3 The explanation is: Microsoft SQL Server provides THREE types of replication for use in distributed APPLICATIONS.

Discussion

36.	Point out the correct statement.(a) Transactional replication is typically used in server-to-server(b) Transactional replication is typically used in client-to-server(c) Transactional replication is typically used in client-to-client(d) None of the mentionedThe question was posed to me in exam.Question is from Replication topic in portion Data Connectivity of SQL Server
Answer» The correct choice is (a) Transactional replication is TYPICALLY used in server-to-server For EXPLANATION I WOULD SAY: Transactional replication is used in scenarios that REQUIRE high throughput, including improving scalability and availability.

Discussion

37.	___________ is a set of technologies for copying and distributing data and database objects from one database to another.(a) Replication(b) Database Mirroring(c) Log Shipping(d) None of the mentionedThe question was posed to me in homework.The above asked question is from Replication in chapter Data Connectivity of SQL Server
Answer» CORRECT OPTION is (a) Replication Easiest explanation: Using replication, you can distribute data to different locations and to remote or mobile users over local and WIDE area networks.

Discussion

38.	Which of the utility is used for reporting the issue in Service Broker?(a) diagnose(b) ssiagnose(c) ssbdiagnose(d) none of the mentionedThis question was posed to me by my school principal while I was bunking the class.Origin of the question is Service Broker topic in division Data Connectivity of SQL Server
Answer» RIGHT option is (c) ssbdiagnose The best explanation: The ssbdiagnose UTILITY reports issues in Service Broker CONVERSATIONS or the configuration of Service Broker SERVICES.

Discussion

39.	Which of the following is a Service Broker Related Dynamic Management View?(a) sys.dm_broker_activated(b) sys.dm_broker_activated_tasks(c) sys.dm_broker_tasks(d) dm_broker_activated_tasksI have been asked this question in an interview for job.The above asked question is from Service Broker topic in division Data Connectivity of SQL Server
Answer» The correct CHOICE is (b) sys.dm_broker_activated_tasks For explanation I would SAY: sys.dm_broker_activated_tasks returns a row for each STORED procedure activated by Service Broker.

Discussion

40.	Which of the following change was introduced in SQL Server 2012 related to Service Broker?(a) Less support for Service Broker(b) Queues do not expose the message enqueued time(c) Messages can be sent to multiple target services (multicast)(d) All of the mentionedI have been asked this question in an interview for job.My enquiry is from Service Broker topic in chapter Data Connectivity of SQL Server
Answer» The correct choice is (c) MESSAGES can be SENT to multiple target services (MULTICAST) To explain I would say: QUEUES have a new column, message_enqueue_time, that shows how long a message has been in the queue.

Discussion

41.	(SSBS) is a new architecture which allows you to write ____________ message based application.(a) asynchronous(b) decoupled(c) distributed(d) all of the mentionedThis question was posed to me in a job interview.Enquiry is from Service Broker in chapter Data Connectivity of SQL Server
Answer» Right answer is (d) all of the mentioned To explain I WOULD say: SQL SERVER Service Broker (SSBS), introduced with SQL Server 2005 allows you to WRITE queuing/message based applications WITHIN the DATABASE itself.

Discussion

42.	Service Broker also provides security by preventing __________ access from networks and by message encryption.(a) Authorized(b) Read(c) Unauthorized(d) All of the mentionedI have been asked this question in homework.My doubt stems from Service Broker topic in portion Data Connectivity of SQL Server
Answer» The CORRECT option is (c) Unauthorized Best explanation: SERVICE broker is essential COMPONENT for security of database.

Discussion

43.	Point out the wrong statement.(a) The developers can design applications from independent components known as “services”(b) The maintenance of the Service Broker is difficult(c) Maintenance of Service Broker is a part of the routine database(d) None of the mentionedThe question was posed to me in homework.The doubt is from Service Broker topic in division Data Connectivity of SQL Server
Answer» The correct ANSWER is (B) The maintenance of the Service Broker is difficult To EXPLAIN I would say: The maintenance of Service Broker is easy because it forms a PART of the DATABASE Engine.

Discussion

44.	Which of the following service broker component defines the infrastructure used for exchanging messages between instances?(a) Conversation(b) Service definition(c) Security(d) All of the mentionedThe question was posed to me in unit test.My enquiry is from Service Broker in portion Data Connectivity of SQL Server
Answer» CORRECT CHOICE is (a) Conversation To ELABORATE: Networking and security components defines the infrastructure used for EXCHANGING messages between instances.

Discussion

45.	There are _________ components of the Service broker in SQL Server.(a) 2(b) 3(c) 4(d) 5I got this question in class test.My question comes from Service Broker topic in section Data Connectivity of SQL Server
Answer» The CORRECT CHOICE is (b) 3 Best explanation: The THREE components of the Service broker are as follows: conversation components, service definition components and NETWORKING and security components.

Discussion

46.	Point out the correct statement.(a) Loosely coupled applications are supported by the Service broker(b) Each Service Broker conversation is considered to be a dialog where only participants are involved(c) Service broker find applications when a single SQL server instance is used(d) None of the mentionedI got this question during a job interview.My question is based upon Service Broker in portion Data Connectivity of SQL Server
Answer» The correct answer is (a) Loosely coupled applications are SUPPORTED by the Service BROKER Explanation: PROGRAMS that exchange MESSAGES independently) are supported by the Service broker.

Discussion

47.	Service broker was added to SQL Server ___________(a) 2000(b) 2005(c) 2008(d) 2012I had been asked this question during an online interview.Question is from Service Broker topic in section Data Connectivity of SQL Server
Answer» Correct OPTION is (b) 2005 The explanation: Service Broker in Microsoft SQL SERVER 2005 is a new TECHNOLOGY that provides messaging and queuing functions between instances.

Discussion

48.	LINQ to SQL in SQL Server fully supports ____________(a) Transactions(b) Functions(c) Stored Procedures(d) All of the mentionedThe question was asked in a national level competition.My question comes from LINQ topic in portion Data Connectivity of SQL Server
Answer» The correct ANSWER is (d) All of the mentioned Explanation: LINQ provides an easy WAY to integrate DATA validation and business logic rules into your data model, and supports SINGLE table INHERITANCE in the object model.

Discussion

49.	__________object is used to fill a DataSet/DataTable with query results in ADO.net.(a) DataReader(b) Dataset(c) DataAdapter(d) DataTablesThis question was posed to me in examination.Query is from ADO.NET in chapter Data Connectivity of SQL Server
Answer» Correct choice is (c) DataAdapter Easiest explanation: A DataAdapter OBJECT can be thought of as the ADAPTER between the connected and disconnected DATA MODELS.

Discussion

50.	The main features of dotConnect for SQL Server includes ___________(a) Extra data binding capabilities(b) Ability of monitoring query execution(c) Supports the latest versions of SQL Server(d) All of the mentionedI have been asked this question in an online interview.I want to ask this question from ADO.NET topic in division Data Connectivity of SQL Server
Answer» The correct option is (d) All of the mentioned Easiest explanation: dotConnect for SQL SERVER includes base-class-based provider model, provider factories, connection STRING builder, metadata schemas, asynchronous commands, pooling ENHANCEMENTS, batch update support, provider-specific types, server ENUMERATION, database change notification support and so on.

Discussion

Explore topic-wise InterviewSolutions in .

__________ 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

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

The following Network perfom counters can help you tune your topology?(a) Total Bandwidth(b) Current Bandwidth(c) Bandwidth bound(d) All of the mentionedThe question was posed to me in unit test.I'm obligated to ask this question of Integration Services in section Data Connectivity of SQL Server

_________ represents to total memory pressure on the system in SSIS.(a) Page sec(b) Page Reads(c) Memory reads(d) All of the mentionedI got this question in an international level competition.My doubt stems from Integration Services in division Data Connectivity of SQL Server

The key counters for Integration Services and SQL Server are _______________(a) Process Bytes(b) Public Bytes(c) Private Set(d) All of the mentionedThis question was posed to me in an online quiz.My question is based upon Integration Services topic in section Data Connectivity of SQL Server

Two types of subscriptions present for replication is _____________(a) push and pull(b) throw and pull(c) push and throw(d) none of the mentionedI got this question during an online exam.Origin of the question is Replication in portion Data Connectivity of SQL Server

Which of the following makes data available for replication?(a) Article(b) Publisher(c) Distributor(d) SubscriptionThe question was asked in an interview for internship.The query is from Replication topic in chapter Data Connectivity of SQL Server

How many types of replication components are present in SQL Server?(a) 6(b) 7(c) 8(d) 9This question was addressed to me in a national level competition.My enquiry is from Replication topic in portion Data Connectivity of SQL Server

Replication in SQL Server is used to overcome ________________(a) Performance problems(b) Availability problems(c) Maintenance problems(d) All of the mentionedThis question was addressed to me in final exam.My doubt is from Replication topic in division Data Connectivity of SQL Server

How many types of replication is provided by SQL Server?(a) 2(b) 3(c) 4(d) 5This question was addressed to me in semester exam.The doubt is from Replication topic in division Data Connectivity of SQL Server

(SSBS) is a new architecture which allows you to write ____________ message based application.(a) asynchronous(b) decoupled(c) distributed(d) all of the mentionedThis question was posed to me in a job interview.Enquiry is from Service Broker in chapter Data Connectivity of SQL Server

Service Broker also provides security by preventing __________ access from networks and by message encryption.(a) Authorized(b) Read(c) Unauthorized(d) All of the mentionedI have been asked this question in homework.My doubt stems from Service Broker topic in portion Data Connectivity of SQL Server

There are _________ components of the Service broker in SQL Server.(a) 2(b) 3(c) 4(d) 5I got this question in class test.My question comes from Service Broker topic in section Data Connectivity of SQL Server

Service broker was added to SQL Server ___________(a) 2000(b) 2005(c) 2008(d) 2012I had been asked this question during an online interview.Question is from Service Broker topic in section Data Connectivity of SQL Server

LINQ to SQL in SQL Server fully supports ____________(a) Transactions(b) Functions(c) Stored Procedures(d) All of the mentionedThe question was asked in a national level competition.My question comes from LINQ topic in portion Data Connectivity of SQL Server

__________object is used to fill a DataSet/DataTable with query results in ADO.net.(a) DataReader(b) Dataset(c) DataAdapter(d) DataTablesThis question was posed to me in examination.Query is from ADO.NET in chapter Data Connectivity of SQL Server