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.

真

偽

新しい質問 51
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(該当するものをすべて選んでください)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

パイソン

新しい質問 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.

真

偽

新しい質問 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

リソースモニター

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.

真

偽

新しい質問 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.

真

偽

新しい質問 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.

真

偽

新しい質問 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.

真

偽