FOCUS QUESTIONS

Question 1

1.1 - What is it in the INFORMATION_SCHEMA

Answer 1

• Views for all the objects contained in the database, as well as views for account-level objects
• Table functions for historical and usage data across your account

Question 2

When to use the REFERENCE_USAGE privilege?

Answer 2

• When sharing a secure view that references objects belonging to multiple databases
• Side note: REFERENCE_USAGE must be granted individually to each database
• Side note: privilege must be granted to a database before granting SELECT on a secure view to share

Question 3

When can the SELECT privilege on views be granted in a share?

Answer 3

• When the view is secured, otherwise an error will return

Question 4

What rules apply to cloning stages?

Answer 4

• Individual external named stages CAN be cloned
• Internal named stages CANNOT be cloned
• ## Tables are cloned, which means their internal table stages are also closed

Question 5

What is the metadata cache used for?

Answer 5

• To optimize queries and improve query compile time

Question 6

What terms are associated with the ‘Cloud Services Layer’

Answer 6

• Query Planning
• Query Optimization
• Query Compilation