exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 57 discussion

Actual exam question from Microsoft's DP-300
Question #: 57
Topic #: 1
[All DP-300 Questions]

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.

You have an Azure subscription that contains an Azure SQL database named SQLDB1.

You need to replicate DB1 to SQLDB1.

Which type of replication should you use?

  • A. transactional
  • B. peer-to-peer
  • C. snapshot
  • D. merge
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
MakkerHeineken
10 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
jerrychan
10 months, 3 weeks ago
Yes, the correct answer is A. Snapshot Replication Applies to: SQL Server Azure SQL Managed Instance. So it's not correct. https://learn.microsoft.com/en-us/sql/relational-databases/replication/snapshot-replication?view=sql-server-ver16
upvoted 1 times
...
igorclapa
10 months, 3 weeks ago
Transactional replication typically starts with a snapshot of the publication database objects and data. As soon as the initial snapshot is taken, subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur (in near real time). The data changes are applied to the Subscriber in the same order and within the same transaction boundaries as they occurred at the Publisher; therefore, within a publication, transactional consistency is guaranteed. https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-replication?view=sql-server-ver16
upvoted 1 times
...
igorclapa
10 months, 3 weeks ago
You can configure an Azure SQL Database as the push subscriber in a one-way transactional or snapshot replication topology. https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql
upvoted 3 times
...
mnluma
11 months ago
Selected Answer: A
A or C, only possible. "Snapshot and one-way transactional replication are supported. Peer-to-peer transactional replication and merge replication are not supported." But definitely, A is the best option according to the statement.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...