SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 41 of 54, with answer review and explanations.

Question 201

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Choose two.)

  1. The ability to scale up warehouses
  2. The use of warehouse auto scaling
  3. The ability to resize warehouses
  4. Use of multi-clustered warehouses
  5. The use of warehouse indexing

Question 202

Which COPY INTO command outputs the data into one file?

  1. SINGLE=TRUE
  2. MAX_FILE_NUMBER=1
  3. FILE_NUMBER=1
  4. MULTIPLE=FALSE

Question 203

In which scenarios would a user have to pay Cloud Services costs? (Choose two.)

  1. Compute Credits = 50 Credits Cloud Services = 10
  2. Compute Credits = 80 Credits Cloud Services = 5
  3. Compute Credits = 100 Credits Cloud Services = 9
  4. Compute Credits = 120 Credits Cloud Services = 10
  5. Compute Credits = 200 Credits Cloud Services = 26

Question 204

A user created a new worksheet within the Snowsight UI and wants to share this with teammates. How can this worksheet be shared?

  1. Create a zero-copy clone of the worksheet and grant permissions to teammates.
  2. Create a private Data Exchange so that any teammate can use the worksheet.
  3. Share the worksheet with teammates within Snowsight.
  4. Create a database and grant all permissions to teammates.

Question 205

How can a row access policy be applied to a table or a view? (Choose two.)

  1. Within the policy DDL
  2. Within the create table or create view DDL
  3. By future APPLY for all objects in a schema
  4. Within a control table
  5. Using the command ALTER [object] ADD ROW ACCESS POLICY [policy];