Free SnowPro Advanced: Data Analyst Exam Practice Questions

A.  

Include the :datebucket system filter in a WHERE clause, and include the :daterange system filter in a GROUP BY clause.

B.  

Include the :daterange system filter in a SELECT clause, and include the :datebucket system filter in a GROUP BY clause.

C.  

Include the :datebucket system filter in a WHERE clause, and include the :daterange system filter in a SELECT clause.

D.  

Include the :daterange system filter in a WHERE clause, and include the :datebucket system filter in a GROUP BY clause.

A.  

Any Value

B.  

Average

C.  

Standard Deviation

D.  

Mode

E.  

HLL

F.  

Max

A.  

SELECT CITY, SUM(ACTIVE_DRIVERS), VARIANCE(AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

B.  

SELECT CITY, VARIANCE(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

C.  

SELECT CITY, SUM(ACTIVE_DRIVERS), AVG(AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

D.  

SELECT CITY, CORR(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

A.  

To detect the file metadata schema from staged data files that contain unstructured data

B.  

To detect the file metadata schema from staged data files that contain semi-structured data

C.  

To detect the metadata schema from a table cell that contains JSON data

D.  

To retrieve the column definitions from a previously-loaded database table

A.  

Line chart

B.  

Heat grid

C.  

Bar chart

D.  

Scatter plot

A.  

The original users retain access and permissions on the worksheet.

B.  

The original users gain additional access to the worksheet.

C.  

The original users temporarily lose access but regain it once the dashboard is created.

D.  

The original users lose access to the worksheet, their permissions on the worksheet are revoked.

A.  

MINHASH

B.  

APPROX_PERCENTILE

C.  

HyperLogLog

D.  

APPROX_TOP_K

A.  

Option A

B.  

Option B

C.  

Option C

D.  

Option D

A.  

Where start_time >= dateadd('days', -7, SYSDATE())

B.  

Where start_time >= dateadd('days', -7, CURRENT_TIMESTAMP())

C.  

Where start_time = :date_filter

D.  

Where start_time = :daterange

A.  

SELECT GET(COL_B, ARRAY_SIZE(COL_B)-1) FROM TB_A;

B.  

SELECT COL_B[ARRAY_SIZE(COL_B)] FROM TB_A;

C.  

SELECT COL_B[-1] FROM TB_A;

D.  

SELECT LAST_VALUE(COL_B) FROM TB_A;