Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 761:

  Which of the following describes external functions in Snowflake?

  A. They are a type of User-defined Function (UDF).

  B. They contain their own SQL code.

  C. They call code that is stored inside of Snowflake.

  D. They can return multiple rows for each row received

  Correct Answer: A

  External functions are user-defined functions that are stored and executed outside of Snowflake.

  External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using

  third-party services, significantly simplifying your data pipelines.

  https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.

• Question 762:

  True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

  A. True

  B. False

  Correct Answer: A

  Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

• Question 763:

  What are ways to create and manage data shares in Snowflake? (Select TWO)

  A. Through the Snowflake web interface (Ul)

  B. Through the DATA_SHARE=TRUE parameter

  C. Through SQL commands

  D. Through the enable__share=true parameter

  E. Using the CREATE SHARE AS SELECT * TABLE command

  Correct Answer: AC

• Question 764:

  Which Snowflake technique can be used to improve the performance of a query?

  A. Clustering

  B. Indexing

  C. Fragmenting

  D. Using INDEX__HINTS

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 765:

  True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

  A. True

  B. False

  Correct Answer: A

  You can experiment the same with snowflake UI.

• Question 766:

  When unloading to a stage, which of the following is a recommended practice or approach?

  A. Set SINGLE: = true for larger files

  B. Use OBJECT_CONSTRUCT ( * ) when using Parquet

  C. Avoid the use of the CAST function

  D. Define an individual file format

  Correct Answer: D

• Question 767:

  Where would a Snowflake user find information about query activity from 90 days ago?

  A. account__usage . query history view

  B. account__usage.query__history__archive View

  C. information__schema . cruery_history view

  D. information__schema-query history_by_ses s i on view

  Correct Answer: A

• Question 768:

  A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

  A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

  B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

  C. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

  D. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

  Correct Answer: A

  https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html#examples