TopExamCollection SnowPro-Core Dumps PDF - 100% Passing Guarantee [Q50-Q66] : Top Exam Collection : http://blog.topexamcollection.com

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

True

False

새 질문 51
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(해당되는 항목을 모두 선택합니다.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

새 질문 52
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
답변 2개 선택

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

새 질문 53
On which of the following cloud platform can a Snowflake account be hosted?
답변 2개 선택

아마존 웹 서비스

Private Virtual Cloud

Oracle Cloud

Microsoft Azure Cloud

새 질문 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

새 질문 55
In which layer of its architecture does Snowflake store its metadata statistics?

Storage Layer

Compute Layer

Database Layer

Cloud Services Layer

새 질문 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

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

True

False

새 질문 58
When creating a user it is advisable sable to:
답변 2개 선택

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

새 질문 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

새 질문 60
What is the recommended Snowflake data type to store semi-structured data like JSON?

VARCHAR

RAW

LOB

VARIANT

새 질문 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

새 질문 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.

새 질문 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

새 질문 64
Fail-safe is unavailable on which table types?

Temporary

Transient

Provisional

Permanent

새 질문 65
Which of the following roles is recommended to be used to create and manage users and roles?

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

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

True

False