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

True or False: You can define multiple columns within a clustering key on a table.

A.False

B.True

Which of the following commands are not blocking operations?
Choose 2 answers

A.UPDATE

B.INSERT

C.COPY

D.MERGE

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

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

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

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

D.A Warehouse can be resized while running

What are the default Time Travel and Fail-safe retention periods for transient tables?

A.Time Travel - 1 day. Fail-safe - 1 day

B.Time Travel - 0 days. Fail-safe - 1 day

C.Time Travel - 1 day. Fail-safe - 0 days

D.Transient tables are retained in neither Fail-safe nor Time Travel

Which interfaces can be used to create and/or manage Virtual Warehouses?

A.SQL commands

B.The Snowflake Web Interface (UI)

C.All of the above

D.Data integration tools

Other Version: 1046Snowflake.SnowPro-Core.v2025-02-18.q136; 1108Snowflake.SnowPro-Core.v2024-03-20.q154; 2364Snowflake.SnowPro-Core.v2022-06-27.q91; 1923Snowflake.SnowPro-Core.v2022-05-06.q56; 2000Snowflake.SnowPro-Core.v2022-03-21.q79; 2362Snowflake.SnowPro-Core.v2021-11-10.q46; 59Snowflake.Exams4sures.SnowPro-Core.v2021-09-20.by.valentine.62q.pdf

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

Download PDF File