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

Q61.

___________ is a set of technologies for copying and distributing data and database objects from one database to another.

Replication

Database Mirroring

Log Shipping

None of the mentioned

Discuss

Answer: (a).Replication

Q62.

Point out the correct statement.

Transactional replication is typically used in server-to-server

Transactional replication is typically used in client-to-server

Transactional replication is typically used in client-to-client

None of the mentioned

Discuss

Answer: (a).Transactional replication is typically used in server-to-server

Q63.

How many types of replication is provided by SQL Server?

Discuss

Answer: (b).3

Q64.

Replication in SQL Server is used to overcome ________________

Performance problems

Availability problems

Maintenance problems

All of the mentioned

Discuss

Answer: (d).All of the mentioned

Q65.

Point out the wrong statement.

Log shipping and mirroring allows to maintain complete database redundancy

Replication allows to maintain some part of the database (a set of required objects) at users location

Replication is object level low availability feature

All of the mentioned

Discuss

Answer: (c).Replication is object level low availability feature

Q66.

Which of the following stored procedure provide replication support for AlwaysOn?

sp_validate_replica_publishers

sp_validate_hosts_as_publishers

sp_validate_replica_hosts_as_publishers

all of the mentioned

Discuss

Answer: (c).sp_validate_replica_hosts_as_publishers

Q67.

How many types of replication components are present in SQL Server?

Discuss

Answer: (c).8

Q68.

Which of the following makes data available for replication?

Article

Publisher

Distributor

Subscription

Discuss

Answer: (b).Publisher

Q69.

Two types of subscriptions present for replication is _____________

push and pull

throw and pull

push and throw

none of the mentioned

Discuss

Answer: (a).push and pull

Q70.

SSMS provides different options to develop your SSIS package starting with ___________ wizard.

Welcome to the Data Connectivity MCQs Page

Data Connectivity MCQs | Page 7 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

Reverse Engineering

Web Technologies

C Programming

Internet of Things (IoT)

JavaScript

HTML

Data Warehousing and OLAP

Systems Programming

IT Fundamentals