Top Tips Of Improve SnowPro-Core Preparation Labs

NEW QUESTION 1

Where can a user find and review the failed logins of a specific user for the past 30 days?

• A. The USERS view in ACCOUNT_USAGE
• B. The LOGIN_HISTORY view in ACCOUNT_USAGE
• C. The ACCESS_HISTORY view in ACCOUNT_USAGE
• D. The SESSIONS view in ACCOUNT_USAGE

Answer: B

NEW QUESTION 2

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

• A. On-premise availability
• B. Simplicity
• C. Open source based
• D. Concurrency
• E. Performance

Answer: BDE

NEW QUESTION 3

True or False: During data unloading, only JSON and CSV files can be compressed.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

NEW QUESTION 4

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

• A. SELECT SUM (ORDER_AMT) FROM SALES;
• B. SELECT AVG(ORDER_QTY) FROM SALES;
• C. SELECT MIN(ORDER_AMT) FROM SALES;
• D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Answer: B

NEW QUESTION 5

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

• A. Number of users
• B. Warehouse size
• C. Amount of data processed
• D. # of clusters for the Warehouse

Answer: BD

Explanation:
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."

NEW QUESTION 6

True or False: It is possible to load data into Snowflake without creating a named File Format object.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

NEW QUESTION 7

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

• A. True
• B. False

Answer: A

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

NEW QUESTION 8

Which statements are true of micro-partitions? Choose 2 answers

• A. They are approximately 16MB in size
• B. They are stored compressed only if COMPRESS=TRUE on Table
• C. They are Immutable
• D. They are only encrypted in the Enterprise edition and above

Answer: AC

Explanation:
Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1- 731ddc983c69

NEW QUESTION 9

Which feature allows a user the ability to control the organization of data in a micro-partition?

• A. Range Partitioning
• B. Search Optimization Service
• C. Automatic Clustering
• D. Horizontal Partitioning

Answer: D

NEW QUESTION 10

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 11

Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

• A. Scaling rhythmically
• B. Scaling max
• C. Scaling out
• D. Scaling up

Answer: D

NEW QUESTION 12

How can a row access policy be applied to a table or a view? (Choose two.)

• A. Within the policy DDL
• B. Within the create table or create view DDL
• C. By future APPLY for all objects in a schema
• D. Within a control table
• E. Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>;

Answer: BD

NEW QUESTION 13

Which of the following commands cannot be used within a reader account?

• A. CREATE SHARE
• B. ALTER WAREHOUSE
• C. DROP ROLE
• D. SHOW SCHEMAS
• E. DESCRBE TABLE

Answer: B

Explanation:
A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.

NEW QUESTION 14

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

• A. A multi-cluster Warehouse can add clusters automatically based on query activity
• B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
• C. A multi-cluster Warehouse can scale down when query activity slows
• D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

Answer: ABCD

NEW QUESTION 15

What COPY INTO SQL command should be used to unload data into multiple files?

• A. SINGLE=TRUE
• B. MULTIPLE=TRUE
• C. MULTIPLE=FALSE
• D. SINGLE=FALSE

Answer: C

NEW QUESTION 16
......