You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLMI1 hosts a database named DB1. You initiate a copy operation of DB1 to SQLMI2. You need to…

Question

Options

• Asys.dm_continuous_copy_status
• Bsys.dm_database_replica_states
• Csys.dm_hadr_physical_seeding_stats
• Dsys.dm_db_mirroring_connections

• A
  6% (2)
• B
  9% (3)
• C
  81% (26)
• D
  3% (1)

Explanation

sys.dm_hadr_physical_seeding_stats (Transact-SQL) On the primary replica, query sys.dm_hadr_physical_seeding_stats DMV to see the physical statistics for each seeding process that is currently running. Note: Seeding is the process of populating a database with initial data, typically used to provide sample or default records for testing and development purposes. You can use this to create "reproducible environments" for local development, staging, and production. https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-database-replica-states-azure-sql-database https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-hadr-physical-seeding-stats

No community discussion yet for this question.