Microsoft
DP-300 · Question #389
Hotspot Question 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. Y
Sign in or unlock DP-300 to reveal the answer and full explanation for question #389. The question stem and answer options stay visible for context.
Submitted by helene.fr· Mar 6, 2026Perform administration by using T-SQL
Question
Hotspot Question 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. Answer:
Exhibit
Answer Area
- Option:CHECK_CONSTRAINTSFIRE_TRIGGERSROWS_PER_BATCH
- Parameter:IGNORE_DUP_KEYUNIQUEWHERE
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Data Sync#BULK INSERT#CREATE INDEX#IGNORE_DUP_KEY