SnowPro-Core Exam - SnowPro Core Certification Exam

NEW QUESTION 1

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_NAMEFROM 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;

Answer: D

NEW QUESTION 2

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

• A. Reader
• B. Consumer
• C. Vendor
• D. Standard
• E. Personalized

Answer: DE

NEW QUESTION 3

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

• A. SHOW GRANTS OF ROLE MY_ROLE
• B. SHOW GRANTS TO ROLE MY_ROLE
• C. SHOW GRANTS FOR ROLE MY_ROLE
• D. SHOW GRANTS ON ROLE MY_ROLE

Answer: B

NEW QUESTION 4

What is the maximum Time Travel retention period for a temporary Snowflake table?

• A. 90 days
• B. 1 day
• C. 7 days
• D. 45 days

Answer: B

NEW QUESTION 5

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

• A. When the system has enough load for 2 minutes
• B. When the system has enough load for 6 minutes
• C. When the system has enough load for 8 minutes
• D. When the system has enough load for 10 minutes

Answer: D

NEW QUESTION 6

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

• A. All data from all of the files on the stage will be appended to the table
• B. Only data about new customers from the new files will be appended to the table
• C. The operation will fail with the error uncertain files in stage.
• D. All data from only the newly-added files will be appended to the table.

Answer: A

NEW QUESTION 7

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?

• A. It removes the last element of the outer array.
• B. It removes the outer array structure and loads the records into separate table rows,
• C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
• D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Answer: B

Explanation:
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO
<table> command to remove the outer array structure and load the records into separate table rows:
copy into <table> from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true); https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

NEW QUESTION 8

Which object allows you to limit the number of credits consumed within a Snowflake account? Select one.

• A. Account usage Tracking
• B. Resource Monitor
• C. Warehouse Limit Parameter
• D. Credit Consumption Tracker

Answer: B

Explanation:
The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."

NEW QUESTION 9

What is a best practice after creating a custom role?

• A. Create the custom role using the SYSADMIN role.
• B. Assign the custom role to the SYSADMIN role
• C. Assign the custom role to the PUBLIC role
• D. Add__CUSTOM to all custom role names

Answer: B

Explanation:
When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

NEW QUESTION 10

Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy? Select one.

• A. Account -> Schema -> Database -> Table
• B. Account -> Database -> Schema -> Table
• C. Database -> Schema -> Table -> Account
• D. Database -> Table -> Schema -> Account

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

NEW QUESTION 11

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

NEW QUESTION 12

Which Snowflake feature is used for both querying and restoring data?

• A. Cluster keys
• B. Time Travel
• C. Fail-safe
• D. Cloning

Answer: B

Explanation:
https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%

NEW QUESTION 13

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

• A. The tables are now orphaned
• B. The user that deleted the role
• C. SYSADMIN
• D. The assumed role that dropped the role

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html

NEW QUESTION 14

Which of the following objects is not covered by Time Travel?

• A. Tables
• B. Schemas
• C. Databases
• D. Stages

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

NEW QUESTION 15

As a best practice, clustering keys should only be defined on tables of which minimum size?

• A. Multi-Kilobyte (KB) Range
• B. Multi-Megabyte (MB) Range
• C. Multi-Gigabyte (GB) Range
• D. Multi-Terabyte (TB) Range

Answer: D

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

NEW QUESTION 16

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

• A. INSERT
• B. PUT
• C. GET
• D. COPY

Answer: D

NEW QUESTION 17

What are supported file formats for unloading data from Snowflake? (Choose three.)

• A. XML
• B. JSON
• C. Parquet
• D. ORC
• E. AVRO
• F. CSV

Answer: BCF

NEW QUESTION 18

How many resource monitors can be assigned at the account level?

• A. 1
• B. 2
• C. 3
• D. 4

Answer: A

NEW QUESTION 19
......