Question 1

What is the SHOW GRANTS SQL command primarily used for?

Options :

A : To view the history of data loads.

B : To display all privileges granted to a role or user.

C : To list all active users in the account.

D : To show current warehouse credit usage.

Answer: B

Question 2

Which options are used in Snowflake notebooks for querying data? (Choose any 3 options)

Options :

A : Python

B : SQL

C : Markup

D : Markdown

Answer: A,B,D

Question 3

What is the default Time Travel data retention period?

Options :

A : 45 days

B : 1 day

C : 7 days

D : 90 days

Answer: B

Question 4

Which SQL command is commonly used to load structured data from a stage into a Snowflake table?

Options :

A : INSERT INTO

B : COPY INTO

C : LOAD DATA

D : IMPORT DATA

Answer: B

Question 5

Which command can be used to query the Information Schema in Snowflake to retrieve a list of tables?

Options :

A : SELECT * FROM PUBLIC.INFORMATION_SCHEMA;

B : SELECT * FROM INFORMATION_SCHEMA.COLUMNS;

C : SELECT * FROM INFORMATION_SCHEMA.TABLES;

D : SELECT * FROM PUBLIC.TABLES;

Answer: C