Exam 70-464 topic 1 question 75 discussion

Actual exam question from Microsoft's 70-464

Question #: 75
Topic #: 1

You are creating a stored procedure named usp1. Usp1 will create a table that will be used during the execution of usp1. Only usp1 will be allowed to access the table.
You need to write the code required to create the table for usp1. The solution must minimize the need to recompile the stored procedure.
Which code segment should you use to create the table?

A. CREATE TABLE oneTable
B. CREATE TABLE ##oneTable
C. CREATE TABLE #oneTable
D. DECLARE oneTable TABLE

Show Suggested Answer

Suggested Answer: B 🗳️

by frkb at Feb. 21, 2020, 7:19 p.m.

Comments

Submit Cancel

Iuliana16

Highly Voted 4 years, 10 months ago

I think that C is the correct answer

upvoted 5 times

...

Zikato

Most Recent 4 years, 4 months ago

#tempTables can also be used by inner scope (nested sprocs). So only a table variable should be correct.

upvoted 1 times

...

Luzix

4 years, 6 months ago

#Table --> If created inside a stored procedure they are destroyed upon completion of the stored procedure. You can use the D but there will be DECLARE @TABLE_NAME TABLE

upvoted 2 times

...

CodeMaestro

4 years, 10 months ago

The answer should be D but its missing the @

upvoted 2 times

...

frkb

5 years, 2 months ago

Only usp1 will be allowed to access the table... B is wrong

upvoted 2 times

...

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam

Exam 70-464 topic 1 question 75 discussion

Comments

Iuliana16

Zikato

Luzix

CodeMaestro

frkb

SY0-701