Free Access Snowflake.SnowPro-Core.v2023-03-14.q81 Practice Test (Page 9)

Question 36

What is the minimum duration charged when starting a virtual warehouse?

A.1 day

B.1 second

C.1 minute

D.1 hour

Question 37

Which of the following statements are true of Snowflake releases: (Choose two.)

A.They happen approximately weekly

B.They roll up and release approximately monthly, but customers can request early release application

C.During a release, new customer requests/queries/connections transparently move over to the newer version

D.A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Question 38

Will data cached in a warehouse be lost when the warehouse is resized?

A.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B.Yes. became the new compute resource will no longer have access to the cache encryption key

C.No. because the size of the cache is independent from the warehouse size

D.Yes. because the compute resource is replaced in its entirety with a new compute resource.

Question 39

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

A.Pipe

B.External stage

C.Task

D.Stream

Question 40

True or False: Pipes can be suspended and resumed.

A.True

B.False

Other Version: 1045Snowflake.SnowPro-Core.v2025-02-18.q136; 1108Snowflake.SnowPro-Core.v2024-03-20.q154; 2363Snowflake.SnowPro-Core.v2022-06-27.q91; 1921Snowflake.SnowPro-Core.v2022-05-06.q56; 1990Snowflake.SnowPro-Core.v2022-03-21.q79; 2352Snowflake.SnowPro-Core.v2021-11-10.q46; 59Snowflake.Exams4sures.SnowPro-Core.v2021-09-20.by.valentine.62q.pdf

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 146Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 204CFAInstitute.ESG-Investing.v2025-09-08.q173; 152PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 176Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File