ExamsTorrent SnowPro-Core Dumps Real Exam Questions Test Engine Dumps Training [Q83-Q102]

Posted byadminAugust 20, 2022Leave a Comment on ExamsTorrent SnowPro-Core Dumps Real Exam Questions Test Engine Dumps Training [Q83-Q102]

Rate this post

ExamsTorrent SnowPro-Core Dumps Real Exam Questions Test Engine Dumps Training

Snowflake SnowPro-Core exam dumps and online Test Engine

NO.83 What is the minimum Snowflake edition that provides data sharing?

Standard

Premier

Enterprise

Business Critical Edition

NO.84 True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

True

False

NO.85 When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history
“When a pipe is recreated, the load history is dropped.”

NO.86 A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers

The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period

The same exact query will return the precomputed results if the underlying data hasn’t changed and the results were last accessed within the previous 24 hour period

The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous

The ”24 hour” on the percomputed results gets renewed every time the exact query is executed

NO.87 As a best practice, clustering keys should only be defined on tables of which minimum size?

Multi-Kilobyte (KB) Range

Multi-Megabyte (MB) Range

Multi-Gigabyte (GB) Range

Multi-Terabyte (TB) Range

NO.88 How would you execute a series of SQL statements using Task?

include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..
INSERT INTO target2 SELECT .. FROM stream .s1 where ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask…. AS call stored_prc1(); call stored_proc2t);

A stored procedure executing multiple SQL statements and invoke the stored procedure from the task.
CREATE TASK mytask…. AS call
stored_proc_multiple_statements_inside():

Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

NO.89 What command is used to load files into an Internal Stage within Snowflake? Select one.

PUT

COPY INTO

TRANSFER

INSERT

You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO <table> command when loading data into a table from the staged files.

NO.90 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.91 Which of the following roles is recommended to be used to create and manage users and roles?

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

NO.92 True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True

False

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

NO.94 True or False: Snowflake charges additional fees to Data providers for each share they create.

True

False

NO.95 A Virtual Warehouse’s auto-suspend and auto-resume settings apply to:

The primary cluster in the Virtual Warehouse

The entire Virtual Warehouse

The database the Virtual Warehouse resides in

The queries currently being run by the Virtual Warehouse

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

NO.96 What is the maximum compressed row size in Snowflake?

8KB

16MB

50MB

4000GB

Explanation
MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.

NO.97 True or False: All Snowflake table types include fail-safe storage.

True

False

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

Temporary

Translent

Provisioned

Permanent

NO.99 A Virtual Warehouse’s auto-suspend and auto-resume settings apply to:

The primary duster in the virtual warehouse

The entire Virtual Warehouse

The database the Virtual Warehouse resides in

The queries currently being run by the Virtual Warehouse

NO.100 Which of the following DML commands isn’t supported by Snowflake?

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

NO.101 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.102 True or False: An active warehouse is required to run a COPY INTO statement.

True

False

Loading …

How much SnowPro Core CertificationCost

The cost of the SnowPro Core Certification is $175. For more information related to exam price, please visit the official website as the cost of exams may be subjected to vary county-wise.

Snowflake SnowPro-Core: Selling SnowPro Core Products and Solutions: https://www.examstorrent.com/SnowPro-Core-exam-dumps-torrent.html