← Back to exam page

Free SnowPro-Core – SnowPro Core Certification Exam Practice Test Question

Free demo downloads

Loading demo links...

Showing 16–18 of 20 questions

Question 16

Which of the following can be executed/called with Snowpipe?

Select an option, then click Submit answer.

  • ○

    A User Defined Function (UDF)
  • ○

    A stored procedure
  • ○

    A single copy_into statement
  • ○

    A single insert__into statement
Question 17

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Select an option, then click Submit answer.

  • ○

    CREATE_SHARE on the account
  • ○

    SHARE on databases and schemas
  • ○

    SELECT on tables used by the secure view
  • ○

    REFERENCE_USAGE on databases
Question 18

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

C:\Users\Admin\Desktop\Data\Odt data\Untitled.jpg

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Select an option, then click Submit answer.

  • ○

    select src:dealership from car_sales;
  • ○

    select src.dealership from car_sales;
  • ○

    select src:Dealership from car_sales;
  • ○

    select dealership from car_sales;