2022 Realistic Dumpleader SnowPro-Core Dumps PDF - 100% Passing Guarantee [Q74-Q95] : IT certification exam materials : http://blog.dumpleader.com

Q74. True or False: Snowflake charges a premium for storing semi-structured data.

True

False

Q75. The fail-safe retention period is how many days?

1 day

7 days

45 days

90 days

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

True

False

Q77. Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

Q78. True or False: It is possible to unload structured data to semi-structured formats such as JSON and Parquet.

True

False

Q79. True or False: It is possible to load data into Snowflake without creating a named File Format object.

True

False

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

Temporary

Transient

Provisioned

Permanent

Q81. What is the maximum compressed row size in Snowflake?

8KB

16MB

50MB

4000GB

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

True

False

Q83. True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

True

False

Q84. Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Q85. Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

Q86. Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

Q87. 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

Q88. True or False: Snowpipe via RFST API can only reference External Stages as source.

True

False

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

Q90. True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

True

False

Q91. Which are true of Snowflake roles?

All grants to objects are given to roles, and never to users

In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

The public role controls at other roles

Roles are a subset of users and users own objects In Snowflake

Q92. 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

Q93. True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

True

False

Q94. True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

True

False

Q95. True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

True

False

2022 Realistic Dumpleader SnowPro-Core Dumps PDF - 100% Passing Guarantee [Q74-Q95]

How to book the SnowPro Core Certification

Who should take the SnowPro Core Certification