Exam DP-300 topic 3 question 64 discussion

Actual exam question from Microsoft's DP-300

Question #: 64
Topic #: 3

HOTSPOT
-

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

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

You need to perform the following actions:

• Sync DB1 with SQLDB1 by using SQL Data Sync.
• Configure an index in DB1 by using CREATE INDEX.
• Add data to DB1 at regular intervals by using BULK INSERT.

Which option should you specify when you use BULK INSERT, and which parameter should you specify when you use CREATE INDEX? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by voodoo_sh at Nov. 18, 2024, 2:52 p.m.

Comments

Submit Cancel

voodoo_sh

5 months, 1 week ago

Option: FIRE_TRIGGERS Data Sync tracks changes using insert, update, and delete triggers. The changes are recorded in a side table in the user database. BULK INSERT doesn't fire triggers by default. If FIRE_TRIGGERS isn't specified, no insert triggers execute. Add the FIRE_TRIGGERS option so Data Sync can track those inserts. Parameter: Data Sync supports only the following two index properties: Unique, Clustered/Non-Clustered. Other properties of an index, like IGNORE_DUP_KEY or the WHERE filter predicate, aren't supported and the destination index is provisioned without these properties even if the source Index has these properties set. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql

upvoted 1 times

...

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 64 discussion

Comments

voodoo_sh

SY0-701