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

A. CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.TRANS_HIST WHERE extract(year from (TRANS_DATE)) = 2019);

B. CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.
TRANS_HIST);

C. CREATE TABLE DEV.PUBLIC.TRANS_HIST LIKE PROD.PUBLIC.TRANS_HIST;

D. CREATE TABLE DEV.PUBLIC.TRANS_HIST CLONE PROD.PUBLIC.TRANS_HIST;

A. UNPIVOT

B. EXCEPT

C. INTERSECT

D. PIVOT

A. ST_LENGTH

B. ST_DISTANCE

C. HAVERSINE

D. ST_HAUSDORFFDISTANCE

A. select avg(total_income), state from taxpayer_wages group by state having state = :state;

B. select avg(total_income), state from taxpayer_wages group by state having state = @state;

C. select avg(total_income), state from taxpayer_wages group by state having state = 'state';

D. select avg(total_income), state from taxpayer_wages group by state having state = state;

A. The name of the function used to generate the filter

B. The table name containing the static filter "key" values

C. The filter name to be inserted into queries

D. The name of a User-Defined Function (UDF) used to define the filter "key" values

A. SYSTEM$ESTIMATE

B. Count(Distinct *)

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

D. HLL(*)

A. DESC RESULT LAST_QUERY_ID();

B. SELECT LAST_QUERY_ID(-1);

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

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