Which statement about bulk inserts is true?

The correct answer is A. Bulk inserts do not work when you issue any FIND statements on the table, and bulk inserts are. Bulk Insert ConstraintsIf you want to write code that uses the bulk insert functionality, you must be aware of the following constraints. Records are sent to SQL Server when the following occurs: - You call COMMIT to commit the transaction. - You call MODIFY or DELETE on the…

Understand the Dynamics 365 for Talent Environment

Question

Options

ABulk inserts do not work when you issue any FIND statements on the table, and bulk inserts are
BIn T-SQL, bulk inserts translate to BULK INSERT, and bulk inserts do not work when you issue any
CBulk inserts are performed when you issue a MODIFY or DELETE statement on the table, and bulk
DIn T-SQL, bulk inserts translate to BULK INSERT, and bulk inserts reduce the time that the table is locked.

How the community answered

(43 responses)

A
74% (32)
B
14% (6)
C
7% (3)
D
5% (2)

Explanation

Bulk Insert ConstraintsIf you want to write code that uses the bulk insert functionality, you must be aware of the following constraints. Records are sent to SQL Server when the following occurs: - You call COMMIT to commit the transaction. - You call MODIFY or DELETE on the table. - You call any FIND or CALC methods on the table. The following code example cannot use buffered inserts because it contains a FIND call on the GL/Entry table within the loop.

Topics

#bulk inserts#T-SQL#table locking#FIND statements

Community Discussion

No community discussion yet for this question.

Full MB7-702 Practice