Term
| What are the three methods of replication? |
|
Definition
| Snapshot, transactional, and merge. p.523 |
|
|
Term
| What are the five agents used in replication? |
|
Definition
| Snapshot, Log Reader, Distribution, Merge, and Queue Reader. p.523 |
|
|
Term
| What are the 3 types of data conflicts? |
|
Definition
| duplicate primary key, update conflict, and update of a nonexistent row. p.523 |
|
|
Term
| What are the 2 roles that a database can have in replication architecture? |
|
Definition
| Publisher or subscriber. p.523 |
|
|
Term
| What are the core components of replication? |
|
Definition
| Articles, Publications, and Filters. One or more articles are combined into a publication that forms the basis of a replication session. The articles can optionally have filters applied to them. p.523 |
|
|
Term
| Replication: What is an Article? |
|
Definition
| basic building block of replication. Defined against a table, view, stored procedure, or function. p.514 |
|
|
Term
| Replication: What is a Publication? |
|
Definition
| Groupings of articles that define the replication set. p.514 |
|
|
Term
Replication: You can filter Articles by:
A: rows
B: columns
C: views
D: tables |
|
Definition
|
|
Term
| Which type of filter is used in high-availabilty replication settings? eg. column, row, ... |
|
Definition
| They are NOT used. High-availabilty architecture is mainly concerned with maintaining a coherent copy of the data. p.515 |
|
|
Term
| What level of role is the distributor? |
|
Definition
|
|
Term
| Central Publisher Topology in a single sentence. |
|
Definition
| A single publisher that has one or more subscribers. Is the most common topology. p.516 |
|
|
Term
| Central Subscriber Topology in a single sentence. |
|
Definition
| A single subscriber that has more than one publisher. p.516 |
|
|
Term
| Draw a Central Publisher Topology. |
|
Definition
|
|
Term
| What is the Central Subscriber Topology normally used for? |
|
Definition
| Consolidating multiple databases or as a central reporting database. p.517 |
|
|
Term
| What infrastructure of the SQL Server engine is Replication built on? |
|
Definition
| Replication is NOT part of the SQL Server engine. It operates outside the engine in the form of an application. p.517 |
|
|
Term
| Snapshot Replication in one sentence. |
|
Definition
| Takes the entire set of data and sends it during each cycle of the replication engine. p.519 |
|
|
Term
Which table objects are preserved in Snapshot replication?
A: primary key
B: contraints
C: foreign keys
D: clustered index
E: unique indexes
F: non-clustered indexes. |
|
Definition
|
|
Term
| Why is Snapshot Replication not normally used for high availability? |
|
Definition
| Because any transactions issued between cycles are not sent to the subscriber. p.519 |
|
|
Term
| Transactional Replication in a sentence. |
|
Definition
| Uses the Log Reader Agent and Distribution Agent to extract committed transactions to the subscriber. p.518/522 |
|
|
Term
Which are valid modes in Transaction Replication:
A: continuous updating
B: immediate updating
C: batch updating
D: queued updating
E: logged updating |
|
Definition
|
|
Term
| Merge Replication in a sentence. |
|
Definition
| Changes are made at both the publisher and subscriber, then merged. p.520 |
|
|
Term
| "Cycle of the replication agent" |
|
Definition
| Replication engine determines whether changes exist, moving the changes to the subscriber, then acknowledging receipt of changes. p.521 |
|
|
Term
| What is a minimally logged transaction? |
|
Definition
| only log page allocations and deallocations into the transaction log; they do not fire triggers. p.522 |
|
|
Term
| List the 5 minimally logged transaction. |
|
Definition
CREATE INDEX
TRUNCATE TABLE
BULK INSERT
BCP
SELECT ... INTO |
|
|
Term
| What are the 3 minimally logged transactions that concern Replication? Why? |
|
Definition
TRUNCATE TABLE, BULK INSERT, and BCP.
Because each affects data within a table. |
|
|
Term
| What happens if a publisher database is placed in the simple or bulk-logged recover mode? |
|
Definition
| The replication engine cannot detect changes made by minimally logged transactions because they are not logged and do not fire any triggers. p.523 |
|
|
Term
Which implements a one way reporting server?
A: Transactional replication
B: Snapshot replication
C: Merge replication
D: Peer-to-peer replication |
|
Definition
A.
B will not work as is causes an outage each time replication is ran. |
|
|
