Free Access Snowflake.COF-C02.v2026-05-31.q637 Practice Test (Page 100)

Question 491

Which command will create an ARRAY output from inputs 'a' and 'b'?

A.AS_ARRAY('a', 'b');

B.ARRAY_CONSTRUCT('a', 'b');

C.LISTAGG('a', 'b');

D.TO_ARRAY('a', 'b');

Question 492

What can the Snowflake SCIM API be used to manage? (Select TWO).

A.Integrations

B.Network policies

C.Session policies

D.Roles

E.Users

Question 493

What actions can be performed by a consumer account on a shared database? (Select TWO)

A.Using Time Travel on a shared table

B.Cloning a shared table

C.Modifying the data in a shared table

D.Executing the select statement on a shared table

E.Joining the data from a shared table with another table

Question 494

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

A.60 minutes

B.30 days

C.24 hours

D.1 year

E.14 days

Question 495

What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

A.Temporary table

B.External table

C.Secure view

D.Materialized view

Other Version: 5283Snowflake.COF-C02.v2025-06-30.q512; 1843Snowflake.COF-C02.v2023-09-01.q136; 1455Snowflake.COF-C02.v2023-02-20.q85

Latest Upload: 147MedicalProfessional.CCM.v2026-08-20.q62; 206Cisco.300-610.v2026-08-19.q170; 205CompTIA.PT0-003.v2026-08-19.q179; 155Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 148SAP.C_CR125_2601.v2026-08-17.q28; 211Salesforce.Field-Service-Consultant.v2026-08-17.q134; 168Oracle.1Z0-1170.v2026-08-16.q64; 176Oracle.1Z1-1170.v2026-08-16.q64; 201Juniper.JN0-336.v2026-08-13.q60; 393EMC.NCP-AII.v2026-08-13.q200

Question 491

Question 492

Question 493

Question 494

Question 495

Download PDF File