TopExamCollection SnowPro-Core Dumps PDF - 100% Passing Guarantee [Q50-Q66]

TopExamCollection SnowPro-Core Dumps PDF – 100% Passing Guarantee [Q50-Q66]

April 18, 2022 admin 0 Comments

4.1/5 - (8 votes)

TopExamCollection SnowPro-Core Dumps PDF – 100% Passing Guarantee

SnowPro-Core Braindumps Real Exam Updated on Apr 18, 2022 with 162 Questions

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

True

False

Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

NEW QUESTION 51
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

NEW QUESTION 52
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

NEW QUESTION 53
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers

Amazon Web Services

Private Virtual Cloud

Oracle Cloud

Microsoft Azure Cloud

NEW QUESTION 54
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

True

False

NEW QUESTION 55
In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Compute Layer

Database Layer

Cloud Services Layer

Explanation/Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

NEW QUESTION 56
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

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

NEW QUESTION 57
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

True

False

NEW QUESTION 58
When creating a user it is advisable sable to:
Choose 2 answers

Set the user to be initially disabled

Force an immediate password change

Set a default role for the user

Set the number of minutes to unlock to 15 minutes

Set the users access to expire within a specified timeframe

NEW QUESTION 59
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True

False

NEW QUESTION 60
What is the recommended Snowflake data type to store semi-structured data like JSON?

VARCHAR

RAW

LOB

VARIANT

NEW QUESTION 61
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

True

False

NEW QUESTION 62
What privileges are required to execute a task?

To execute a task, you need the EXECUTE TASK.

A task is an account-level object and can only be executed by the Account Admin role.

Tasks run automatically and do run under any rote.

Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

NEW QUESTION 63
Which of the following statements is true of data loading?
Select one.

Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

The “deal file size for loading is 16MB to match micro-partition size

Marry files in the 10-lOOMB range tend to land In the ‘sweet spot” for load parallelism Once loaded, there is no option to force a reload of an already loaded file

NEW QUESTION 64
Fail-safe is unavailable on which table types?

Temporary

Transient

Provisional

Permanent

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

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

True