Microsoft Discussions

Exam 70-762 All Questions

View all questions & answers for the 70-762 exam

Go to Exam

Exam 70-762 topic 1 question 74 discussion

Actual exam question from Microsoft's 70-762

Question #: 74
Topic #: 1

[All 70-762 Questions]

Note: This question is part of a series of questions that use the same answer choices. An answer choice may be correct for more than one question in the series.
Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are developing an application to track customer sales. You create tables to support the application. You need to create a database object that meets the following data entry requirements:

What should you create?

A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. DDL trigger
F. scalar-valued function
G. table-valued function

Show Suggested Answer

Suggested Answer: C 🗳️
References:
https://msdn.microsoft.com/en-us/library/ms345075.aspx

by JohnFan at March 8, 2020, 7:28 a.m.

Comments

Submit Cancel

MML

Highly Voted 4 years, 11 months ago

Answer C is correct

upvoted 14 times

Braindripper

4 years, 5 months ago

but why is correct? you cannot do inserts into DB with UDFs!

upvoted 1 times

Braindripper

4 years, 5 months ago

just read again its not udf its UDP -procedure that says on C so its correct - appolgise cannot delete comment as well haha

upvoted 2 times

BabyBee

4 years, 5 months ago

Ha, ha, ha! :D

upvoted 1 times

...

...

...

...

Barbedx

Most Recent 4 years, 5 months ago

but what a difference between A. extended procedure and C. user-defined procedure ?

upvoted 1 times

...

kimalto452

4 years, 6 months ago

correct

upvoted 2 times

...

JohnFan

5 years, 3 months ago

CLR (Common Language Runtime) These are procedures that are written in a .NET language and have a Transact-SQL calling mechanism.

upvoted 1 times

...