Which SQL statement will require a virtual warehouse to run?

• A.SELECT COUNT{*) FROM TBL_EMPLOYEE;
• B.ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);
• C.INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam*,20000,* Finance');
• D.CREATE OR REPLACE TABLE TBL_EMPLOYEE (

Comment: *

Name: *

Email: *

Verification: *

How does the Snowflake search optimization service improve query performance?

• A.It improves the performance of range searches.
• B.It improves the performance of all queries running against a given table.
• C.It improves the performance of equality searches.
• D.It defines different clustering keys on the same source table.

Comment: *

Name: *

Email: *

Verification: *

Which cache type is used to cache data output from SQL queries?

• A.Metadata cache
• B.Result cache
• C.Remote cache
• D.Local file cache

Comment: *

Name: *

Email: *

Verification: *

What are the three layers that make up Snowflake's architecture? Choose 3 answer

• A.Compute
• B.Cloud Services
• C.Tri-Secret Secure
• D.Storage

Comment: *

Name: *

Email: *

Verification: *

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

• A.Create a task that runs a GET operation to intermittently check for new files
• B.Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
• C.Create a task that puts the files in an internal stage and automate the data loading wizard
• D.Create a task that runs a copy into operation from an external stage every 5 minutes

Comment: *

Name: *

Email: *

Verification: *