MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.You plan to synchronize SQLDev and SQLProd.You need to recommend a solution that meets the following requirements:
A
A database snapshot
B
SQL Server Integration Services (SSIS)
C
Change data capture
D
A data-tier application
Explanation: 

Detailed explanation-1: -You can run multiple instances of the Database Engine on a computer. One instance can be the default instance. The default instance has no name.

Detailed explanation-2: -You can install multiple instances of SQL Server, or install SQL Server on a computer where earlier SQL Server versions are already installed. The following SQL Server-related items are compatible with the installation of multiple instances on the same computer: Database Engine. Analysis Services.

Detailed explanation-3: -Synchronization by automatically generated SQL is only provided by SQL Database Studio. SQL Database Studio provides a similar interface to the data compare method. We need to select the source and target (databases or tables). Then we need to set up options (sync keys, pairing and mapping).

There is 1 question to complete.
Previous
Next