Back

Practice Free SnowPro Core Exam Online Questions

Question #101

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 all tables in schema DB1.SCHEMA to role MYROLE;
  • B . grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
  • C . grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
  • D . grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
  • E . grant SELECT on all tables in database DB1 to role MYROLE;
  • F . grant SELECT on future tables in database DB1 to role MYROLE;

Reveal Solution Hide Solution

Question #102

How can a data provider ensure that a data consumer is going to have access to the required objects?

  • A . Enable the data sharing feature in the account and validate the view.
  • B . Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
  • C . Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
  • D . Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

Reveal Solution Hide Solution

Question #103

What is the recommended way to change the existing file format type in my format from CSV to JSON?

  • A . ALTER FILE FORMAT my_format SET TYPE=JSON;
  • B . ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
  • C . CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
  • D . REPLACE FILE FORMAT my format TYPE-JSON;

Reveal Solution Hide Solution

Question #104

Which stage type can be altered and dropped?

  • A . Database stage
  • B . External stage
  • C . Table stage
  • D . User stage

Reveal Solution Hide Solution