[May-2023] Updated and Accurate SnowPro-Core Questions & Answers for passing the exam Quickly [Q236-Q253]

NO.236 What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Business Critical Edition

Standard Edition

Virtual Private Snowflake (VPS)

Enterprise Edition

NO.237 On which of the following cloud platforms can a Snowflake account be hosted? (Choose three.)

Amazon Web Services

Private Virtual Cloud

Oracle Cloud

Microsoft Azure Cloud

Google Cloud Platform

Alibaba Cloud

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

NO.239 Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

NO.240 Which formats are supported for unloading data from Snowflake?
Choose 2 answers

Delimited (CSV, TSV, etc.)

Avro

ISON

ORC

NO.241 True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

True

False

NO.242 Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

1 Hour

3 Hours

12 hours

24 hours

NO.243 What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Reader

Consumer

Vendor

Standard

Personalized

NO.244 Which command sets the Virtual Warehouse for a session?

COPY WAREHOUSE FROM <<config file>>;

SET WAREHOUSE = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

NO.245 Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Pipes

Streams

Tasks

Procedures

NO.246 Which statements are true of micro-partitions?
Choose 2 answers

They are approximately 16MB in size

They are stored compressed only if COMPRESS=TRUE on Table

They are Immutable

They are only encrypted in the Enterprise edition and above

NO.247 What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

NO.248 Which of the following commands cannot be used within a reader account?

CREATE SHARE

ALTER WAREHOUSE

DROP ROLE

SHOW SCHEMAS

DESCRBE TABLE

NO.249 True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

NO.250 Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Each Snowflake account can be hosted in a different cloud vendor and region.

Each Snowflake account must be hosted in a different cloud vendor and region

All Snowflake accounts must be hosted in the same cloud vendor and region

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

NO.251 True or False: The COPY command must specify a File Format in order to execute.

True

False

NO.252 What privilege should a user be granted to change permissions for new objects in a managed access schema?

Grant the OWNERSHIP privilege on the schema.

Grant the OWNERSHIP privilege on the database.

Grant the MANAGE GRANTS global privilege.

Grant ALL privileges on the schema.

NO.253 Which of the following describes a Snowflake stored procedure?

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller’s rights or an owner’s rights.

[May-2023] Updated and Accurate SnowPro-Core Questions & Answers for passing the exam Quickly [Q236-Q253]

Leave a Reply Cancel reply

Related Post

[2023] Valid ARA-C01 test answers & Snowflake ARA-C01 exam pdf [Q62-Q79]

Snowflake COF-C02 Cert Guide PDF 100% Cover Real Exam Questions [Q286-Q304]

Latest 2026 Realistic Verified ADA-C01 Dumps – 100% Free ADA-C01 Exam Dumps [Q37-Q58]