Free SnowPro Core Sample Questions — SnowPro Core

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

• A. Data is live, ready-to-query, and can be personalized
• B. Data needs to be loaded into a cloud provider as a consumer account
• C. Data is not available for copying or moving to an individual Snowflake account
• D. Data is available without copying or moving
• E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake

What command should be used to move data from a Snowflake database table into one or more files in an external stage?

• A. GET
• B. COPY INTO
• C. PUT
• D. SHOW

A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

• A. The primary cluster in the Virtual Warehouse
• B. The entire Virtual Warehouse
• C. The database the Virtual Warehouse resides in
• D. The queries currently being run by the Virtual Warehouse

What Snowflake objects can be added to a share? (Choose two.)

• A. Views
• B. Tables
• C. Stored procedures
• D. Streams
• E. Secure views

What general guideline does Snowflake recommend when setting the auto-suspension time limit?

• A. Set tasks for immediate suspension
• B. Set tasks for suspension after 5 minutes
• C. Set query warehouses for suspension after 15 minutes
• D. Set query warehouses for suspension after 30 minutes

What happens to the privileges granted to Snowflake system-defined roles?

• A. The privileges cannot be revoked
• B. The privileges can be revoked by an ACCOUNTADMIN
• C. The privileges can be revoked by an ORGADMIN
• D. The privileges can be revoked by any user-defined role with appropriate privileges

What is the name of the SnowSQL file that can store connection information?

• A. history
• B. config
• C. snowsql.cnf
• D. snowsql.pubkey

What are the recommended steps to address poor SQL query performance due to data spilling? (Choose two.)

• A. Clone the base table
• B. Fetch required attributes only
• C. Use a larger virtual warehouse
• D. Process the data in smaller batches
• E. Add another cluster in the virtual warehouse

Which command will unload data from a table into an external stage?

• A. PUT
• B. INSERT
• C. COPY INTO [location]
• D. GET

What activities can a user with the ORGADMIN role perform? (Choose two.)

• A. Create INFORMATION_SCHEMA in a database
• B. View usage information for all accounts in the organization
• C. Enable database cloning for an account in the organization
• D. Enable database replication for an account in the organization
• E. View micro-partition information for all accounts in the organization

Snowpark provides libraries for which programming languages? (Choose two.)

• A. JavaScript
• B. Python
• C. Scala
• D. R
• E. C++

Which actions can be performed using a resource monitor in Snowflake? (Choose two.)

• A. Monitor the performance of individual queries in real-time
• B. Automatically allocate more storage space to a virtual warehouse
• C. Modify the queries being executed within a virtual warehouse
• D. Suspend a virtual warehouse when its credit usage reaches a defined limit
• E. Trigger a notification to account administrators when credit usage reaches a specified threshold

What is Snowflake's general guideline for files used to load data?

• A. Files can be loaded directly into a table
• B. Any delimiter is supported: the default is a semicolon
• C. Electronic Data Interchange (EDI) is one of the supported semi-structured formats
• D. For delimited files, the default character set is UTF-8

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

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

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

• A. Area chart
• B. Box plot
• C. Heat grid
• D. Pie chart

What is used to limit the credit usage of a virtual warehouse within a Snowflake account?

• A. Load monitor
• B. Resource monitor
• C. Query Profile
• D. Stream

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called MKTG_WH. Which of the following statements will accommodate this request?

• A. ALLOW RESIZE ON WAREHOUSE MKTG_WH TO USER MKTG_LEAD;
• B. GRANT MODIFY ON WAREHOUSE MKTG_WH TO ROLE MARKETING;
• C. GRANT MODIFY ON WAREHOUSE MKTG_WH TO USER MKTG_LEAD;
• D. GRANT OPERATE ON WAREHOUSE MKTG_WH TO ROLE MARKET;

Which activities are managed by Snowflake’s Cloud Services layer? (Choose two.)

• A. Authentication
• B. Access delegation
• C. Data pruning
• D. Data compression
• E. Query parsing and optimization

Which statement accurately describes a characteristic of a materialized view?

• A. materialized view can query only a single table
• B. Data accessed through materialized views can be stale
• C. Materialized view refreshes need to be maintained by the user
• D. Querying a materialized view is slower than executing a query against the base table of the view

Which DDL/DML operation is allowed on an inbound data share?

• A. ALTER TABLE
• B. INSERT INTO
• C. MERGE
• D. SELECT