Abreast Of The Times SnowPro Core Certification Exam SnowPro-Core Practice Question

NEW QUESTION 1

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 2

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

• A. True
• B. False

Answer: B

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

NEW QUESTION 3

When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

• A. When users will be using compute at different times throughout a 24/7 period
• B. When managing a steady workload
• C. When the compute must be available with no delay or lag time
• D. When you don’t want to have to manually turn on the Warehouse each time a user needs it

Answer: BC

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

NEW QUESTION 4

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A. Customer-managed encryption keys through Tri-Secret Secure
• B. Automatic encryption of all data
• C. Up to 90 days of data recovery through Time Travel
• D. Object-level access control
• E. Column-level security to apply data masking policies to tables and views

Answer: BD

Explanation:
https://docs.snowflake.com/en/user-guide/intro-editions.html

NEW QUESTION 5

The is the minimum Fail-safe retention time period for transient tables?

• A. 1 day
• B. 7 days
• C. 12 hours
• D. 0 days

Answer: D

NEW QUESTION 6

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

• A. A directory table is a separate database object.
• B. Directory tables store data file metadata.
• C. A directory table will be automatically added to a stage.
• D. Directory tables do not have their own grantable privileges.
• E. Directory table data can not be refreshed manually.

Answer: BD

NEW QUESTION 7

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

• A. 30 days
• B. 7 days
• C. 48 hours
• D. 24 hours

Answer: D

NEW QUESTION 8

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;

Answer: A

NEW QUESTION 9

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 10

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A. Load files that are approximately 25 MB or smaller.
• B. Remove all dates and timestamps.
• C. Load files that are approximately 100-250 MB (or larger)
• D. Avoid using embedded characters such as commas for numeric data types
• E. Remove semi-structured data types

Answer: CD

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

NEW QUESTION 11

What privileges are required to execute a task?

• A. To execute a task, you need the EXECUTE TASK.
• B. A task is an account-level object and can only be executed by the Account Admin role.
• C. Tasks run automatically and do run under any rote.
• D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

Answer: A

NEW QUESTION 12

Which of the following are benefits of micro-partitioning? (Select TWO)

• A. Micro-partitions cannot overlap in their range of values
• B. Micro-partitions are immutable objects that support the use of Time Travel.
• C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• D. Rows are automatically stored in sorted order within micro-partitions
• E. Micro-partitions can be defined on a schema-by-schema basis

Answer: AD

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

NEW QUESTION 13

The fail-safe retention period is how many days?

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

Answer: B

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

NEW QUESTION 14

Snowflake is designed for which type of workloads? (Choose two.)

• A. OLAP (Analytics) workloads
• B. OLTP (Transactional) workloads
• C. Concurrent workloads
• D. On-premise workloads

Answer: AC

Explanation:
Reference: https://blog.couchbase.com/its-the-workload-stupid/
https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

NEW QUESTION 15

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 16

Which SQL command can be used to see the CREATE definition of a masking policy?

• A. SHOW MASKING POLICIES
• B. DESCRIBE MASKING POLICY
• C. GET_DDL
• D. LIST MASKING POLICIES

Answer: C

NEW QUESTION 17

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

• A. Use the DROP <file> command after the load completes.
• B. Specify the TEMPORARY option when creating the file format.
• C. Specify the PURGE copy option in the COPY INTO <table> command.
• D. Use the REMOVE command after the load completes.
• E. Use the DELETE LOAD HISTORY command after the load completes.

Answer: CD

NEW QUESTION 18

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A. Schema
• B. View
• C. Internal stage
• D. Table
• E. User
• F. Role

Answer: AD

NEW QUESTION 19

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

• A. Files
• B. External tables
• C. Secure User-Defined Functions (UDFs)
• D. Sequences
• E. Streams

Answer: BC

NEW QUESTION 20
......