Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 711:

  What SQL command would be used to view all roles that were granted to user.1?

  A. show grants to user USER1;

  B. show grants of user USER1;

  C. describe user USER1;

  D. show grants on user USER1;

  Correct Answer: A

• Question 712:

  Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

  A. Each Snowflake account can be hosted in a different cloud vendor and region.

  B. Each Snowflake account must be hosted in a different cloud vendor and region

  C. All Snowflake accounts must be hosted in the same cloud vendor and region

  D. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

  Correct Answer: A

• Question 713:

  Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

  A. Materialized views

  B. Sequences

  C. Procedures

  D. Tables

  E. Secure User Defined Functions (UDFs)

  Correct Answer: DE

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs

  https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

• Question 714:

  A sales table FCT_SALES has 100 million records. The following Query was executed

  SELECT COUNT (1) FROM FCT__SALES;

  How did Snowflake fulfill this query?

  A. Query against the result set cache

  B. Query against a virtual warehouse cache

  C. Query against the most-recently created micro-partition

  D. Query against the metadata excite

  Correct Answer: D

• Question 715:

  When is the result set cache no longer available? (Select TWO)

  A. When another warehouse is used to execute the query

  B. When another user executes the query

  C. When the underlying data has changed

  D. When the warehouse used to execute the query is suspended

  E. When it has been 24 hours since the last query

  Correct Answer: CE

• Question 716:

  Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

  A. The user has the appropriate privileges on the objects associated with the query

  B. Micro-partitions have been reclustered since the query was last run

  C. The new query is run using the same virtual warehouse as the previous query

  D. The query includes a User Defined Function (UDF)

  E. The query has been run within 24 hours of the previously-run query

  Correct Answer: AE

• Question 717:

  Which of the following objects can be shared through secure data sharing?

  A. Masking policy

  B. Stored procedure

  C. Task

  D. External table

  Correct Answer: D

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.

  https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables

• Question 718:

  Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

  A. An FTP server with TLS encryption

  B. An HTTPS server with WebDAV

  C. A Google Cloud storage bucket

  D. A Windows server file share on Azure

  Correct Answer: C

• Question 719:

  A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

  A. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;

  B. SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())

  C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;

  D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

  Correct Answer: D

• Question 720:

  Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

  A. ORC

  B. XML

  C. Avro

  D. Parquet

  E. JSON

  Correct Answer: DE

  Semi-structured JSON, Parquet

  https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20fileandtext=Delimited%20(CSV%2C%20TSV%2C%20etc.)