[Jun-2022] Verified Snowflake SnowPro-Core Bundle Real Exam Dumps PDF [Q23-Q41]

2 Jun, 2022 By admin SnowPro-Core, Snowflake 0 Comments

[Jun-2022] Verified Snowflake SnowPro-Core Bundle Real Exam Dumps PDF [Q23-Q41]

Rate this post

[Jun-2022] Verified Snowflake SnowPro-Core Bundle Real Exam Dumps PDF

SnowPro-Core Dumps PDF New [2022] Ultimate Study Guide

NO.23 Which statement best describes “clustering”?

Clustering represents the way data is grouped together and stored within Snowflake’s micro-partitions

The database administrator must define the clustering methodology for each Snowflake table

The clustering key must be included on the COPY command when loading data into Snowflake

Clustering can be disabled within a Snowflake account

Explanation/Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

NO.24 True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

True

False

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

Explanation
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”

NO.26 When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Concurrency

Performance

NO.27 True or false: it is best practice to define a clustering key on every table.

True

False

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

Delimited (CSV, TSV, etc.)

Avro

ISON

ORC

NO.29 True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True

False

Explanation

NO.30 Select the three types of tables that exist within Snowflake.
Choose 3 answers

Temporary

Translent

Provisioned

Permanent

NO.31 What is the most granular object that the Time Travel retention can be defined on?
Select one.

Account

Database

Schema

Table

NO.32 What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers

On-premise availability

Simplicity

Open source based

Concurrency

Performance

NO.33 Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

To accommodate more queries

To accommodate more users

To accommodate fluctuations in workload

To accommodate a more complex workload

Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html

NO.34 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.35 Which of the following statements would be used to export/unload data from Snowflake?

COPY INTO @stage

EXPORT TO @stage

INSERT INTO @stage

EXPORT_TO_STAGE(stage = > @Wage, select = > ‘select * from t1);

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

True

False

NO.37 Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.

NO.38 True or False: Snowflake charges additional fees to Data Providers for each Share they create.

True

False

Explanation/Reference: https://1amiydhcmj36tz3733v94f15-wpengine.netdna-ssl.com/wp-content/uploads/2017/08/ Enabling-new-products-and-services-with-Snowflake-Data-Sharing.pdf

NO.39 True or False: Data Providers can share data with only the Data Consumer.

True

False

NO.40 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

NO.41 Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

SECURITYADMIN ACCOUNTADMIN, SYSADMIN

SECURITYADMIN, ACCOUNTADMIN

ACCOUNTADMIN

Loading …