[2026] Snowflake SnowPro Advanced: Data Analyst Certification

문제1

What will the following query return?
SELECT * FROM testtable SAMPLE BLOCK (0.012) REPEATABLE (99992);

A. A sample of a table in which each block of rows has a 0.012% probability of being included in the sample, with the seed set to 99992.

B. A sample containing 99992 records of a table in which each block of rows has a 0.012% probability of being included in the sample.

C. A sample of a table in which each block of rows has a 1.2% probability of being included in the sample, with the seed set to 99992.

D. A sample of a table in which each block of rows has a 1.2% probability of being included in the sample where repeated elements are allowed.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제2

A Data Analyst needs to temporarily hide a tile in a dashboard. The data will need to be available in the future, and additional data may be added. Which tile should be used?

A. Delete

B. Unplace

C. Duplicate

D. Show/Hide

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제3

A Data Analyst has been asked to predict sales revenue through the end of the year. Which function will provide this information?

A. REGR_SLOPE

B. CORR

C. VARIANCE

D. COVAR_SAMP

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제4

A Data Analyst needs to rotate a table by transforming a wide table's columns into rows.

Which operator will be MOST beneficial for producing this output?

A. EXCEPT

B. PIVOT

C. INTERSECT

D. UNPIVOT

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제5

A Data Analyst created a model called modelX using SNOWFLAKE.ML.FORECAST. The Analyst needs to predict the next few values and save the result directly into tableX. What step does the Analyst need to take after calling the modelX!FORECAST function?

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.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제6

What option would allow a Data Analyst to efficiently estimate cardinality on a data set that contains trillions of rows?

A. HLL(*)

B. Count(Distinct *)

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

D. SYSTEM$ESTIMATE

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제7

Which query will provide this data without incurring additional storage costs?

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 LIKE PROD.PUBLIC.TRANS_HIST;

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

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

정답: C

설명: (Fast2test 회원만 볼 수 있음)

Snowflake SnowPro Advanced: Data Analyst Certification - DAA-C01무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트