Snowflake SnowPro-Core SnowPro Core Certification Exam Exam Practice Test Questions

• Question 1

  - (Exam Topic 1) Which Snowflake technique can be used to improve the performance of a query?

  • Clustering
  • Indexing
  • Fragmenting
  • Using INDEX__HINTS

  Show Answer Answer: A Next

• Question 2

  - (Exam Topic 3) Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

  • Resource monitor
  • Account_usage. query_history
  • Information_schema.warehouse_load_history
  • Information schema.warehouse metering history

  Show Answer Answer: B Next

• Question 3

  - (Exam Topic 2) Which of the following objects are contained within a schema? (Choose two.)

  • Role
  • Stream
  • Warehouse
  • External table
  • User
  • Share

  Show Answer Answer: C,D Next

• Question 4

  - (Exam Topic 3) What does Snowflake recommend regarding database object ownership? (Select TWO).

  • Create objects with ACCOUNTADMIN and do not reassign ownership.
  • Create objects with SYSADMIN.
  • Create objects with SECURITYADMIN to ease granting of privileges later.
  • Create objects with a custom role and grant this role to SYSADMIN.
  • Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

  Show Answer Answer: B,D Next

• Question 5

  - (Exam Topic 3) How would a user execute a series of SQL statements using a task?

  • Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
  • A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
  • Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
  • Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

  Show Answer Answer: D Next