Microsoft
70-457 · Question #75
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements: - Status information must be logged to a status table. - If the status…
The correct answer is D. Stored procedure. See the full explanation below for the reasoning.
Question
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements:
- Status information must be logged to a status table.
- If the status table does not exist at the beginning of the batch, it
must be created. Which object should you use?
Options
- AScalar user-defined function
- BInline user-defined function
- CTable-valued user-defined function
- DStored procedure
How the community answered
(43 responses)- A9% (4)
- B5% (2)
- C14% (6)
- D72% (31)
Community Discussion
No community discussion yet for this question.