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 (EMP_ID NUMBER,EMP_NAME VARCHAR(30),EMP_SALARY NUMBER, DEPT VARCHAR{20));

Comment: *

Name: *

Email: *

Verification: *

A size Small standard virtual warehouse running in auto-suspend mode is used for a production Business Intelligence (BI) reporting environment. The BI reports generate quickly in the early morning, but as the day progresses and there are more users, it takes longer to run the reports. How can this situation be addressed?

• A.Increase the size of the virtual warehouse.
• B.Disable the auto-suspend mode.
• C.Change the standard warehouse to a multi-cluster warehouse.
• D.Enable the query acceleration service.

Comment: *

Name: *

Email: *

Verification: *

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

• A.PUT
• B.INSERT
• C.COPY INTO <location>
• D.GET

Comment: *

Name: *

Email: *

Verification: *

Using which object-level parameters will help limit query processing and concurrency slowdowns? (Select TWO).

• A.Isolation Levels: Adjusting transaction isolation levels (e.g., read committed, repeatable read) can help manage concurrency and prevent deadlocks.
• B.Connection Pool Size: Limiting the number of concurrent database connections helps reduce congestion and can improve overall performance.
• C.Max Query Execution Time: Setting a timeout for queries ensures that long-running queries don't consume resources and slow down the system for other queries.
• D.Query Caching: Enabling or fine-tuning query caching can reduce the need to re-execute expensive queries multiple times.

Comment: *

Name: *

Email: *

Verification: *

When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

• A.(10,4)
• B.(12,2)
• C.(15,9)
• D.(14,8)

Comment: *

Name: *

Email: *

Verification: *