True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which cache type is used to cache data output from SQL queries?

• A.Metadata cache
• B.Result cache
• C.Remote cache
• D.Local file cache

Comment: *

Name: *

Email: *

Verification: *

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

• A.grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
• B.grant SELECT on all tables in database DB1 to role MYROLE;
• C.grant SELECT on future tables in database DB1 to role MYROLE;
• D.grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
• E.grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
• F.grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

Comment: *

Name: *

Email: *

Verification: *

Which feature allows a user the ability to control the organization of data in a micro-partition?

• A.Automatic Clustering
• B.Horizontal Partitioning
• C.Search Optimization Service
• D.Range Partitioning

Comment: *

Name: *

Email: *

Verification: *

How are serverless features billed?

• A.Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
• B.Per second multiplied by an automatic sizing for the job
• C.Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account
• D.Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

Comment: *

Name: *

Email: *

Verification: *