exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 146 discussion

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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a stored procedure that will be used by hundreds of users concurrently.
You need to store rows that will be processed later by the stored procedure. The object that stores the rows must meet the following requirements:
✑ Be indexable
✑ Contain up-to-date statistics
✑ Be able to scale between 10 and 100,000 rows
The solution must prevent users from accessing one another's data.
Solution: You create a local temporary table in the stored procedure.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
Abhilash_KK
Highly Voted 5 years, 9 months ago
it is mentioned "The solution must prevent users from accessing one another’s data.". So should it be local temporary table?
upvoted 17 times
mattia_88
5 years, 8 months ago
YES, no global temporary table
upvoted 5 times
...
...
daniel_yes23
Highly Voted 5 years, 2 months ago
correct answer is A and the previews question should be B.
upvoted 9 times
...
Billybob0604
Most Recent 4 years, 5 months ago
"You are building a stored procedure that will be used by hundreds of users concurrently." You will not be able to access the local temp table if you choose for A. Answer is B.
upvoted 1 times
...
mch185
4 years, 5 months ago
Answer is A . tested
upvoted 1 times
...
Vermonster
4 years, 5 months ago
A, Final answer :-)
upvoted 1 times
...
TatyanaY
4 years, 8 months ago
I think there is confusion in understanding this and the previous question. They don't ask about an object CREATED by this stored procedure, but rather about the object USED by this SP. Whatever would be the output of the SP, it depends on parameters and perhaps the logics inside of it, thus the data access will be regulated; but all the users would be able to use the preselected data set - global temp table - which is faster than each of them accessing the underlying tables.
upvoted 1 times
...
TheDUdeu
4 years, 11 months ago
Local table people, how can another user access it? B is right.
upvoted 2 times
TheDUdeu
4 years, 11 months ago
Meant A is correct.
upvoted 4 times
...
...
ivanbtod
5 years, 5 months ago
I think it's NO, hint 'contain up to date statistics'
upvoted 2 times
MarcusJB
5 years, 4 months ago
But temporary temp tables can have indexes and statistics like any other table.
upvoted 3 times
...
...
moehijawe
5 years, 5 months ago
There are two types of temporary tables: local and global. Local temporary tables are visible only to their creators during the same connection to an instance of SQL Server as when the tables were first created or referenced. Local temporary tables are deleted after the user disconnects from the instance of SQL Server. Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.
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
Loading ...