What Actual SnowPro-Core Test Preparation Is

NEW QUESTION 1

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

• A. Enterprise
• B. Business Critical
• C. Standard
• D. Virtual Private Snowflake

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition

NEW QUESTION 2

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

• A. True
• B. False

Answer: A

Explanation:
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

NEW QUESTION 3

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers

• A. SnowSQL
• B. ODBC
• C. R
• D. HIVE

Answer: AB

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

NEW QUESTION 4

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

• A. Create a zero-copy clone of the worksheet and grant permissions to teammates
• B. Create a private Data Exchange so that any teammate can use the worksheet
• C. Share the worksheet with teammates within Snowsight
• D. Create a database and grant all permissions to teammates

Answer: C

NEW QUESTION 5

Which formats does Snowflake store unstructured data in? (Choose two.)

• A. GeoJSON
• B. Array
• C. XML
• D. Object
• E. BLOB

Answer: DE

NEW QUESTION 6

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 7

What internal stages are available in Snowflake? (Choose three.)

• A. Schema stage
• B. Named stage
• C. User stage
• D. Stream stage
• E. Table stage
• F. Database stage

Answer: ABE

NEW QUESTION 8

Which copy INTO command outputs the data into one file?

• A. SINGLE=TRUE
• B. MAX_FILE_NUMBER=1
• C. FILE_NUMBER=1
• D. MULTIPLE=FAISE

Answer: A

NEW QUESTION 9

What features does Snowflake Time Travel enable?

• A. Querying data-related objects that were created within the past 365 days
• B. Restoring data-related objects that have been deleted within the past 90 days
• C. Conducting point-in-time analysis for Bl reporting
• D. Analyzing data usage/manipulation over all periods of time

Answer: B

Explanation:
Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:
Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted.
Duplicating and backing up data from key points in the past.
Analyzing data usage/manipulation over specified periods of time.
https://docs.snowflake.com/en/user-guide/data-time-travel.html

NEW QUESTION 10

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 11

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

• A. In the metadata of the target table for 14 days
• B. In the metadata of the pipe for 14 days
• C. In the metadata of the target table for 64 days
• D. In the metadata of the pipe for 64 days

Answer: A

NEW QUESTION 12

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

• A. Use auto-ingest Snowpipes to load large files in a serverless model.
• B. Produce the largest files possible, reducing the overall number of files to process.
• C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
• D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Answer: B

NEW QUESTION 13

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

• A. Database replication and failover
• B. Automated index management
• C. Customer managed keys (Tri-secret secure)
• D. Extended time travel
• E. Native support for geospatial data

Answer: AD

NEW QUESTION 14

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

• A. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 day
• B. Fail Safe retention time is 1 day.
• C. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 day
• D. Fail Safe retention time is 7 days.
• E. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 day
• F. Fail Safe retention time is 7 days.
• G. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 day
• H. Fail Safe retention time is 7 days.
• I. Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 da
• J. Fail Safe retention time is 90 days.
• K. Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 day
• L. Fail Safe retention time is 356 days.

Answer: D

NEW QUESTION 15

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 16

Which of the following significantly improves the performance of selective point lookup queries on a table?

• A. Clustering
• B. Materialized Views
• C. Zero-copy Cloning
• D. Search Optimization Service

Answer: A

NEW QUESTION 17

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

• A. Configure the Maximum Clusters setting to “Auto-Scale”
• B. Set the Warehouse type to “Auto”
• C. Set the Minimum Clusters and Maximum Clusters settings to the same value
• D. Set the Minimum Clusters and Maximum Clusters settings to the different values

Answer: D

Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

NEW QUESTION 18

True or False the longer the data retention period, the higher the resulting storage costs.

• A. True
• B. False

Answer: A

NEW QUESTION 19

In which layer of its architecture does Snowflake store its metadata statistics? Select one.

• A. Storage Layer
• B. Compute Layer
• C. Database Layer
• D. Cloud Service Layer

Answer: D

Explanation:
Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

NEW QUESTION 20
......