Online Access Free Snowflake.SnowPro-Core.v2023-10-17.q145 Practice Test (Page 10)

SnowPro-Core Exam Question 41

What can be used to view warehouse usage over time? (Select Two).

A.The show warehouses command

B.The load HISTORY view

C.The WAREHOUSE_METERING__HISTORY View

D.The Query history view

E.The billing and usage tab in the Snowflake web Ul

SnowPro-Core Exam Question 42

A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

A.Query against the most-recently created micro-partition

B.Query against the metadata excite

C.Query against a virtual warehouse cache

D.Query against the result set cache

SnowPro-Core Exam Question 43

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

A.4

B.8

C.16

D.32

SnowPro-Core Exam Question 44

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

A.Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days.

B.Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

C.Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days.

D.Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days.

E.Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day.

F.Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days.

SnowPro-Core Exam Question 45

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

A.PURGE

B.MODIFY

C.REMOVE

D.DELETE

Other Version: 5642Snowflake.SnowPro-Core.v2024-05-18.q402; 2442Snowflake.SnowPro-Core.v2023-08-17.q139; 3418Snowflake.SnowPro-Core.v2023-03-11.q166; 2915Snowflake.SnowPro-Core.v2023-02-18.q160; 3069Snowflake.SnowPro-Core.v2022-12-07.q131; 3020Snowflake.SnowPro-Core.v2022-03-22.q88; 93Snowflake.Prep4surereview.SnowPro-Core.v2022-03-12.by.clyde.88q.pdf; 2987Snowflake.SnowPro-Core.v2021-11-20.q68

Latest Upload: 134VMware.6V0-21.25.v2026-09-05.q33; 225HashiCorp.Terraform-Associate-004.v2026-09-05.q165; 362PMI.CAPM.v2026-09-05.q632; 147SAVEInternational.CVS.v2026-09-04.q65; 122Fortinet.NSE6_FSM_AN-7.4.v2026-09-04.q20; 176USGBC.LEED-Green-Associate.v2026-09-04.q201; 165Microsoft.AB-731.v2026-09-03.q37; 144TheSecOpsGroup.CCPenX-Az.v2026-09-03.q15; 221EMC.D-VXR-DY-01.v2026-09-03.q159; 346EC-COUNCIL.312-49.v2026-09-02.q265

SnowPro-Core Exam Question 41

SnowPro-Core Exam Question 42

SnowPro-Core Exam Question 43

SnowPro-Core Exam Question 44

SnowPro-Core Exam Question 45

Download PDF File