Exam 70-461 topic 1 question 153 discussion

Actual exam question from Microsoft's 70-461

Question #: 153
Topic #: 1

SIMULATION -
You have a SQL Server database that contains all of the customer data for your company.
The solution must minimize impact on server resources.
You need to extract a random 1,000 row sample from a table named Customers.
Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it.

Show Suggested Answer

Suggested Answer: Please review the explanation part for this answer.
TABLESAMPLE SYSTEM (1000 ROWS)
Update line 3 to get the following:
SELECT *

FROM Customers -
TABLESAMPLE SYSTEM (1000 ROWS)
The TABLESAMPLE clause limits the number of rows returned from a table in the FROM clause to a sample number orPERCENT of rows.
Syntax: TABLESAMPLE [SYSTEM] (sample_number [ PERCENT | ROWS ] )
References:
https://technet.microsoft.com/en-us/library/ms189108(v=sql.105).aspx

by [deleted] at April 4, 2025, 11:15 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!