Question 1

Which types of notation are used to traverse semi-structured data natively in Snowflake? Select all that apply.

Options :

A : Dot notation.

B : Bracket notation.

C : Colon notation.

D : Dollar notation.

Answer: A,B

Question 2

A 2.5 TB sales fact table is queried 90% of the time with predicates on ORDER_DATE and REGION_CODE (approximately 150 distinct regions). The remaining 10% of queries are ad-hoc and use various columns. In which scenario is defining a clustering key most beneficial?

Options :

A : The table receives 50 million new rows daily via COPY commands

B : The table is joined daily with a 5 GB dimension table on REGION_CODE

C : The table is constantly updated with DELETE and UPDATE statements on random rows

D : Most queries contain WHERE ORDER_DATE BETWEEN … and filter on REGION_CODE

Answer: D

Question 3

Which of the following statements about Snowflake's access control is true?

Options :

A : Access control is based solely on role-based access control (RBAC).

B : A securable object can have multiple owners at any given time.

C : Privileges are assigned directly to users, not roles.

D : Access control uses both discretionary and role-based access control models.

Answer: D

Question 4

What is the function of the AUTO_SUSPEND property of a Virtual Warehouse? Choose one correct value.

Options :

A : Specifies if a Virtual Warehouse should be suspended immediately after its created.

B : Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it.

C : Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.

D : Specifies the max threshold of queries after which point a virtual warehouse will be automatically suspended.

Answer: C

Question 5

True or False: When a zero-copy clone of a database is created in Snowflake, the privileges on the database itself and all child objects are automatically inherited by the cloned database.

Options :

A : False

B : True

Answer: A