ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam
Go to Exam

Exam 70-761 topic 1 question 197 discussion

Actual exam question from Microsoft's 70-761
Question #: 197
Topic #: 1
[All 70-761 Questions]

DRAG DROP -
You are a developing a solution to manage employee training records. You have the following Transact-SQL statement:

You need to create a stored procedure that returns the total number of participants for a specific course.
How should you complete the procedure? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
by chaoxes at July 23, 2020, 11:04 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
chaoxes
Highly Voted 4 years, 11 months ago
Solution is correct. Had it on exam and passed with 970 score.
upvoted 11 times
...
NickNnack
Most Recent 4 years, 5 months ago
@totalParticipants should be the bigint, @courseId is declared as an int
upvoted 1 times
...
lh2607
4 years, 6 months ago
Why would we be using big int here?
upvoted 2 times
eggzamtaker
4 years, 5 months ago
Nothing you can do about it. That's what it is declared as.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel