Far Out SnowPro-Core Brain Dumps For SnowPro Core Certification Exam Certification

NEW QUESTION 1

Which statement is true about running tasks in Snowflake?

• A. A task can be called using a CALL statement to run a set of predefined SQL commands.
• B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
• C. A task allows a user to execute a set of SQL commands on a predefined schedule.
• D. A task can be executed using a SELECT statement to run a predefined SQL command.

Answer: C

NEW QUESTION 2

How many shares can be consumed by single Data Consumer?

• A. 1
• B. 10
• C. 100, but can be increased by contacting support
• D. Unlimited

Answer: D

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

NEW QUESTION 3

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

• A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
• B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
• C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
• D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
• E. grant SELECT on all tables in database DB1 to role MYROLE;
• F. grant SELECT on future tables in database DB1 to role MYROLE;

Answer: CD

NEW QUESTION 4

Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers

• A. Temporary Tables
• B. Transient Tables
• C. Provisional Tables
• D. Permanent Tables

Answer: AB

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

NEW QUESTION 5

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

• A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
• B. The transient table version cannot be retrieved after 24 hours.
• C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
• D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Answer: B

NEW QUESTION 6

Which type of table corresponds to a single Snowflake session?

• A. Temporary
• B. Translent
• C. Provisional
• D. Permanent

Answer: A

Explanation:
Snowflake supports creating temporary tables
for storing non-permanent, transitory data (e.g. ETL data,
session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creatin

NEW QUESTION 7

What is the most granular object that the Time Travel retention period can be defined on? Select one.

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

Answer: D

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

NEW QUESTION 8

What is the minimum duration charged when starting a virtual warehouse?

• A. 1 second
• B. 1 minute
• C. 1 hour
• D. 1 day

Answer: B

NEW QUESTION 9

True or False: You can query the files in an External Stage directly without having to load the data into a table.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

NEW QUESTION 10

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 11

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

• A. USERADMIN
• B. PUBLIC
• C. ORGADMIN
• D. SYSADMIN

Answer: D

NEW QUESTION 12

When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.

• A. Concurrency
• B. Performance

Answer: B

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-perfor

NEW QUESTION 13

Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

• A. Micro-partitions
• B. Clustering keys
• C. Key partitions
• D. Clustered partitions

Answer: B

Explanation:
Reference: https://community.snowflake.com/s/article/Snowflake-What-the-Cluster

NEW QUESTION 14

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 15

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

• A. To accommodate more queries
• B. To accommodate more users
• C. To accommodate fluctuations in workload
• D. To accommodate a more complex workload

Answer: D

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

NEW QUESTION 16
......