Free Access Snowflake.SnowPro-Core.v2022-06-27.q91 Practice Test (Page 12)

Snowflake is designed for which type of workloads? (Choose two.)

A.On-premise workloads

B.Concurrent workloads

C.OLAP (Analytics) workloads

D.OLTP (Transactional) workloads

Which of the following DML commands isn't supported by Snowflake?

A.MERGE

B.UPDATE

C.UPSERT

D.TRUNCATE TABLE

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

A.A Warehouse can be configured to suspend after a period of inactivity

B.A Warehouse can be configured to auto-resume when new queries are submitted

C.Customers can change the size of the Warehouse after creation

D.A Warehouse can be resized while running

In which layer of its architecture does Snowflake store its metadata statistics?

A.Storage Layer

B.Compute Layer

C.Database Layer

D.Cloud Services Layer

The fail-safe retention period is how many days?

A.1 day

B.90 days

C.45 days

D.7 days

Other Version: 1928Snowflake.SnowPro-Core.v2025-02-18.q136; 1593Snowflake.SnowPro-Core.v2024-03-20.q154; 1978Snowflake.SnowPro-Core.v2023-03-14.q81; 2164Snowflake.SnowPro-Core.v2022-05-06.q56; 2288Snowflake.SnowPro-Core.v2022-03-21.q79; 2628Snowflake.SnowPro-Core.v2021-11-10.q46; 59Snowflake.Exams4sures.SnowPro-Core.v2021-09-20.by.valentine.62q.pdf

Latest Upload: 200PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 292Nokia.4A0-113.v2026-05-01.q69; 250EC-COUNCIL.312-49v11.v2026-04-30.q214; 227Microsoft.MB-820.v2026-04-30.q101; 207Salesforce.MC-202.v2026-04-30.q57; 203BICSI.INSTC_V8.v2026-04-29.q53; 332NMLS.MLO.v2026-04-28.q82; 241NCARB.Project-Management.v2026-04-28.q27; 457EMC.D-AV-DY-23.v2026-04-27.q184; 1107ServiceNow.CSA.v2026-04-27.q483

Download PDF File