How do you refresh a materialized view?

• A.ALTER VIEW <MV_NAME> REFRESH
• B.REFRESH MATERIALIZED VIEW <MV_NAME>
• C.Materialized views are automatically refreshed by snowflake and does not require manual intervention

Comment: *

Name: *

Email: *

Verification: *

Where can you define the file format settings?

• A.While creating named file formats
• B.In the named stage definition
• C.In the table definition
• D.Directly in the COPY INTO TABLE statement when loading data

Comment: *

Name: *

Email: *

Verification: *

Which metrics below will help you take a decision if you need to resize your warehouse?

• A.QUERY_HISTORY.BYTES_SCANNED
• B.QUERY_HISTORY.SCANNED_ROWS
• C.QUERY_HISTORY.REMOTE_SPILLAGE_BYTES

Comment: *

Name: *

Email: *

Verification: *

You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.
What may be the most possible cause of this.

• A.There may be a symptom on skew in your data where one of the value of the column is significantly more than rest of the values in the column
• B.Since you have configured an warehouse with a low auto-suspend value, your warehouse is going down frequently
• C.Your warehouses do not have enough memory

Comment: *

Name: *

Email: *

Verification: *

Which of the below commands lists all the pipes for which you have access?

• A.SHOW PIPES()
• B.LIST PIPES()
• C.LIST @PIPES
• D.Display Pipes()

Comment: *

Name: *

Email: *

Verification: *