Online Access Free Snowflake.SnowPro-Core.v2024-05-18.q402 Practice Test (Page 67)

Which of the following roles is recommended to be used to create and manage users and roles?

A.SECURITYADMIN

B.ACCOUNTADMIN

C.PUBLIC

D.SYSADMIN

Which of the following commands sets the Virtual Warehouse for a session?

A.SET warehouse = <<warehouse name>>;

B.USE VIRTUAL_WAREHOUSE <<warehouse name>>;

C.COPT WAREHOUSE FROM <<Config file> ;

D.USE WAREHOUSE <<warehouse name>>;

Which feature allows a user the ability to control the organization of data in a micro-partition?

A.Range Partitioning

B.Automatic Clustering

C.Horizontal Partitioning

D.Search Optimization Service

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A.The shared objects are transferred.

B.The shared objects become accessible.

C.The shared objects can be re-shared.

D.The shared objects are copied.

What do temporary and transient tables have m common in Snowflake? (Select TWO).

A.Both tables have no Fail-safe period.

B.Both tables have data retention period maximums of one day.

C.Both tables are visible only to a single user session.

D.For both tables the retention period ends when the tables are dropped.

E.For both tables, the retention period does not end when the session ends

Other Version: 2325Snowflake.SnowPro-Core.v2023-10-17.q145; 2029Snowflake.SnowPro-Core.v2023-08-17.q139; 2916Snowflake.SnowPro-Core.v2023-03-11.q166; 2516Snowflake.SnowPro-Core.v2023-02-18.q160; 2661Snowflake.SnowPro-Core.v2022-12-07.q131; 2697Snowflake.SnowPro-Core.v2022-03-22.q88; 92Snowflake.Prep4surereview.SnowPro-Core.v2022-03-12.by.clyde.88q.pdf; 2824Snowflake.SnowPro-Core.v2021-11-20.q68

Latest Upload: 151IIBA.ECBA.v2026-06-24.q96; 182Microsoft.AI-102.v2026-06-24.q184; 118Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-06-24.q31; 120EMC.D-PDM-DY-23.v2026-06-24.q16; 206ECCouncil.312-50v13.v2026-06-24.q254; 131F5.F5CAB5.v2026-06-22.q29; 132Juniper.JN0-650.v2026-06-22.q31; 153Salesforce.Plat-Admn-201.v2026-06-22.q72; 170VMware.3V0-21.25.v2026-06-20.q29; 170Microsoft.AB-731.v2026-06-19.q23

Download PDF File