SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ20

Manage and maintain database objects and virtual warehouses

An Administrator must create a sample from the LINEITEM table. The sample must not be repeatable, and the sampling function must select data in blocks of rows.

Which SELECT command generates a sample of 20% of the table?

Explanation

SYSTEM sampling selects blocks of rows according to the supplied percentage probability. With no SEED or REPEATABLE clause, repeated executions can produce different samples. SYSTEM (20) therefore provides non-repeatable, block-based sampling at 20%.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!