Question 1

What type of query will benefit from the query acceleration service?

Options :

A : Queries without filters or aggregation

B : Queries with large scans and selective filters

C : Queries where the GROUP BY has high cardinality

D : Queries of tables that have search optimization service enabled

Answer: B

Question 2

What does a table with a clustering depth of 1 mean in Snowflake?

Options :

A : The table has only 1 micro-partition.

B : The table has 1 overlapping micro-partition.

C : The table has no overlapping micro-partitions.

D : The table has no micro-partitions.

Answer: C

Question 3

How can network and private connectivity security be managed in Snowflake?

Options :

A : By setting up network policies with IPv4 IP addresses

B : By putting the Snowflake URL on the allowed list for get method responses

C : By manually setting up vulnerability patch management policies

D : By manually setting up an Intrusion Prevention System (IPS) on each account

Answer: A

Question 4

Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually 24 hours a day, 7 days a week? (Select TWO).

Options :

A : -1

B : 0

C : 86400

D : 172800

E : NULL

Answer: C,D

Question 5

When an object is created in Snowflake. who owns the object?

Options :

A : The public role

B : The user's default role

C : The current active primary role

D : The owner of the parent schema

Answer: C

Higher Test Marks with Free Online SnowPro-Core Exam Practice