최신Snowflake SnowPro Advanced: Data Analyst Certification - DAA-C01무료샘플문제

A. To enforce that records with a NOT NULL column must have values in that column.

B. To allow for clustering on the primary and foreign keys by specifying them as clustering keys.

C. To enforce that records with a UNIQUE column must have all distinct values in that column.

D. To enable team members to see how tables relate to one another.

E. To enforce that a value in a foreign key must match the value of a primary or unique key in a parent table.

A. SELECT LAST_QUERY_ID(-1);

B. SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

C. SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY());

D. DESC RESULT LAST_QUERY_ID();

A. Stored procedure

B. Common Table Expressions (CTE)

C. User-Defined Function (UDF)

D. Materialized view

A. MINHASH

B. APPROX_TOP_K

C. APPROX_PERCENTILE

D. HyperLogLog

A. HLL(*)

B. SYSTEM$ESTIMATE

C. Count(Distinct *)/Count(*)

D. Count(Distinct *)

A. Stored procedure

B. Common Table Expressions (CTE)

C. User-Defined Function (UDF)

D. Materialized view

A. Load the function call results directly INTO tableX.

B. Pass the new table as a function argument.

C. Create the table by querying the RESULT_SCAN.

D. List the cache content, then use the data saved in the RESULT_SCAN for tableX.