Get Ready to Pass the SnowPro-Core exam with Snowflake Latest Practice Exam [Q202-Q219] – IT Certification Exam Questions & Answers

Rate this post

Get Ready to Pass the SnowPro-Core exam with Snowflake Latest Practice Exam

Get Prepared for Your SnowPro-Core Exam With Actual Snowflake Study Guide!

QUESTION 202
Which of the following are characteristics of security in Snowflake?

Account and user authentication is only available with the Snowflake Business Critical edition.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

QUESTION 203
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When you don’t want to have to manually turn on the Warehouse each time a user needs it

QUESTION 204
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.

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

https://docs.snowflake.com/en/user-guide/security-access-control-overview.html
“Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles”

QUESTION 206
Which statement describes how Snowflake supports reader accounts?

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

QUESTION 207
True or False: Users are able to see the result sets of queries executed by other users that share their same role.

True

False

Explanation/Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

QUESTION 208
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

True

False

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

60 minutes

24 hours

14 days

30 days

1 year

Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

QUESTION 210
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

No virtual warehouse will be used, data will be read from the result cache.

No virtual warehouse will be used, data will be read from the local disk cache.

The default virtual warehouse will be used to read all data.

The virtual warehouse that is defined at the session level will be used to read all data.

QUESTION 211
Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

QUESTION 212
Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.

Account usage Tracking

Resource Monitor

Warehouse Limit Parameter

Credit Consumption Tracker

The time travel data retention can be overwritten at the table level “When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command.”

QUESTION 213
True or False: You can resize a Virtual Warehouse while queries are running.

True

False

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

True

False

QUESTION 215
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

Reference:
separate-storage-and-compute-65d2dffd450f

QUESTION 216
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

Reference:
separate-storage-and-compute-65d2dffd450f

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

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

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

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

QUESTION 218
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

QUESTION 219
What is the name of the SnowSQLfile that can store connection information?

history

config

snowsqLcnf

snowsql.pubkey

Loading …