What will happen to partitions if a table is cloned and the original table type is then changed from permanent to transient?

• A.Both old and new partitions will be changed to transient, and the original table type will change to transient.
• B.Old partitions will be changed to transient, and any new partitions added to the clone will follow the transient lifecycle.
• C.Old partitions will not be changed to transient, but any new partitions added to the clone will follow the transient lifecycle.
• D.Both old and new partitions will be changed to transient, but the original table will keep the original table type.

Comment: *

Name: *

Email: *

Verification: *

What is the relationship between a Query Profile and a virtual warehouse?

• A.A Query Profile can help users right-size virtual warehouses.
• B.A Query Profile defines the hardware specifications of the virtual warehouse.
• C.A Query Profile can help determine the number of virtual warehouses available.
• D.A Query Profile automatically scales the virtual warehouse based on the query complexity.

Comment: *

Name: *

Email: *

Verification: *

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: *

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

• A.MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters
• B.MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters
• C.MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters
• D.MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters

Comment: *

Name: *

Email: *

Verification: *

A user frequently runs a reporting query that returns the total record count and the minimum and maximum timestamp from a 100 TB fact table.
The table is loaded once per week and remains static between loads. The reporting query runs hundreds of times per day and causes significant warehouse-credit consumption because it repeatedly scans the fact table.
Which object will improve performance, minimize repeated query-compute costs, and provide the fastest response time?

• A.Standard view
• B.Dynamic table
• C.Temporary table
• D.Materialized view

Comment: *

Name: *

Email: *

Verification: *