adplus-dvertising

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.

frame-decoration

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

Q61.
___________ 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 mentioned

Discuss
Answer: (a).Replication
Q62.
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 mentioned

Discuss
Answer: (a).Transactional replication is typically used in server-to-server
Q63.
How many types of replication is provided by SQL Server?

a.

2

b.

3

c.

4

d.

5

Discuss
Answer: (b).3
Q64.
Replication in SQL Server is used to overcome ________________

a.

Performance problems

b.

Availability problems

c.

Maintenance problems

d.

All of the mentioned

Discuss
Answer: (d).All of the mentioned
Q65.
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 mentioned

Discuss
Answer: (c).Replication is object level low availability feature
Q66.
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 mentioned

Discuss
Answer: (c).sp_validate_replica_hosts_as_publishers
Q67.
How many types of replication components are present in SQL Server?

a.

6

b.

7

c.

8

d.

9

Discuss
Answer: (c).8
Q68.
Which of the following makes data available for replication?

a.

Article

b.

Publisher

c.

Distributor

d.

Subscription

Discuss
Answer: (b).Publisher
Q69.
Two types of subscriptions present for replication is _____________

a.

push and pull

b.

throw and pull

c.

push and throw

d.

none of the mentioned

Discuss
Answer: (a).push and pull
Q70.
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 mentioned

Discuss
Answer: (a).Import and Export
Page 7 of 10

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Software Engineering

Learn about the systematic approach to developing software with our Software...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...