What does the Activity area of Snowsight allow users to do? (Select TWO).

Explore each step of an executed query.

Monitor queries executed by users in an account.

Schedule automated data backups.

Explore each step of an executed query.

Monitor queries executed by users in an account.

Create and manage user roles and permissions.

Access Snowflake Marketplace to find and integrate datasets.

When a Snowflake user loads CSV data from a stage, which copy into <table> command guideline should they follow?

The number of columns in each row should be consistent.

The CSV field delimiter must be a comma character (*,'),

The number of columns in each row should be consistent.

The data file in the stage must be in a compressed format.

The data file must have the same number of columns as the target table.

How do secure views compare to non-secure views in Snowflake?

There are no performance differences between secure and non-secure views.

Secure views execute slowly compared to non-secure views.

Non-secure views are preferred over secure views when sharing data.

Secure views are similar to materialized views in that they are the most performant.

There are no performance differences between secure and non-secure views.

How can a Snowflake user post-process the result of SHOW FILE FORMATS?

Create a CURSOR for the command.

Put it in the FROM clause in brackets.

Assign the command to RESULTSET.

Which SQL statement will require a virtual warehouse to run?

INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam*,20000,* Finance');

SELECT COUNT{*) FROM TBL_EMPLOYEE;

ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);

INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam*,20000,* Finance');

CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR{20) );

Which statement accurately describes how a virtual warehouse functions?

Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

Increasing the size of a virtual warehouse will always improve data loading performance.

Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.

Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).

Performing aggregate calculations

What consideration should be made when loading data into Snowflake?

The number of data files that are processed in parallel is determined by the virtual warehouse.

Create small data files and stage them in cloud storage frequently.

Create large data files to maximize the processing overhead for each file.

The number of load operations That run in parallel can exceed the number of data files to be loaded.

The number of data files that are processed in parallel is determined by the virtual warehouse.

When should a multi-cluster virtual warehouse be used in Snowflake?

When queuing is delaying query execution on the warehouse

When there is significant disk spilling shown on the Query Profile

When dynamic vertical scaling is being used in the warehouse

When there are no concurrent queries running on the warehouse

How does the Snowflake search optimization service improve query performance?

It improves the performance of equality searches.

It improves the performance of range searches.

It defines different clustering keys on the same source table.

It improves the performance of all queries running against a given table.

It improves the performance of equality searches.

It improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table's columns, which significantly speeds up the retrieval of rows based on those equality search conditions. This optimization is particularly beneficial for large tables where traditional scans might be inefficient for equality searches. By using the Search Optimization Service, Snowflake can leverage the search indexes to quickly locate the rows that match the search criteria without scanning the entire table.

What compute resource is used when loading data using Snowpipe?

Snowpipe uses compute resources provided by Snowflake.

Snowpipe uses virtual warehouses provided by the user.

Snowpipe uses an Apache Kafka server for its compute resources.

Snowpipe uses compute resources provided by Snowflake.

Snowpipe uses cloud platform compute resources provided by the user.

What is one of the characteristics of data shares?

Data shares utilize secure views for sharing view objects.

Data shares support full DML operations.

Data shares work by copying data to consumer accounts.

Data shares utilize secure views for sharing view objects.

Data shares are cloud agnostic and can cross regions by default.

Snowflake SnowPro Core Practice Test 16 - Free Online Exam Questions 601-627

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Snowflake SnowPro Core Practice Test 16

Question

Snowflake SnowPro Core Practice Tests

Practice Tests