ExamGecko
Login
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 44

List of questions

Question 431

Report Export Collapse

Which of the following SQL statements will list the version of the drivers currently being used?

Become a Premium Member for full access
  Unlock Premium Member

Question 432

Report Export Collapse

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 433

Report Export Collapse

Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?

Become a Premium Member for full access
  Unlock Premium Member

Question 434

Report Export Collapse

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON <object> <object_name> To SHARE <share_name>;

Become a Premium Member for full access
  Unlock Premium Member

Question 435

Report Export Collapse

How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

Become a Premium Member for full access
  Unlock Premium Member

Question 436

Report Export Collapse

Which object type is granted permissions for reading a table?

Become a Premium Member for full access
  Unlock Premium Member

Question 437

Report Export Collapse

When should a stored procedure be created with caller's rights?

Become a Premium Member for full access
  Unlock Premium Member

Question 438

Report Export Collapse

Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

Become a Premium Member for full access
  Unlock Premium Member

Question 439

Report Export Collapse

By default, which role can create resource monitors?

Become a Premium Member for full access
  Unlock Premium Member

Question 440

Report Export Collapse

What happens to the privileges granted to Snowflake system-defined roles?

Become a Premium Member for full access
  Unlock Premium Member
Total 627 questions
Go to page: of 63
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a key feature of Snowflake architecture?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).