COF-R02無料問題集「Snowflake SnowPro Core Recertification」

質問 1

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?

（A）The reader account can clone data the provider has shared, but cannot re-share it.

（B）The reader account compute will be billed to the provider account.

（C）The reader account can create a copy of the shared data using CREATE TABLE AS...

（D）The reader account will automatically use the Standard edition of Snowflake.

正解：A 解答を投票する

質問 2

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

（A）Compute Credits = 50 Credits Cloud Services = 10

（B）Compute Credits = 80 Credits Cloud Services = 5

（C）Compute Credits = 10 Credits Cloud Services = 9

（D）Compute Credits = 200 Credits Cloud Services = 26

（E）Compute Credits = 120 Credits Cloud Services = 10

正解：B、E 解答を投票する

質問 3

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

（A）IS_SECURE

（B）TABLE_NAME

（C）CHECK_OPTION

（D）IS_UPDATEABLE

正解：A 解答を投票する

質問 4

How many resource monitors can be assigned at the account level?

（A）3

（B）1

（C）4

（D）2

正解：B 解答を投票する

質問 5

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

（A）False

（B）True

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

How long is the Fail-safe period for temporary and transient tables?

（A）1 day

（B）7 days

（C）31 days

（D）90 days

（E）There is no Fail-safe period for these tables.

正解：E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

（A）Compress the file and load the compressed file.

（B）Split the file into multiple files in the recommended size range (100 MB - 250 MB).

（C）Use a larger-sized warehouse.

（D）Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

正解：A 解答を投票する

質問 8

What is the purpose of an External Function?

（A）To share data in Snowflake with external parties

（B）To call code that executes outside of Snowflake

（C）To run a function in another Snowflake database

（D）To ingest data from on-premises data sources

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

（A）Secure User-Defined Functions (UDFs)

（B）Tables

（C）Stored Procedures

（D）Schemas

（E）Roles

（F）Secure Views

正解：A、D、E 解答を投票する

質問 10

When loading data into Snowflake, how should the data be organized?

（A）Into single files with 100-250 MB of compressed data per file

（B）Into files of maximum size of 1 GB of compressed data per file

（C）Into single files with 1-100 MB of compressed data per file

（D）Into files of maximum size of 4 GB of compressed data per file

正解：A 解答を投票する

質問 11

The fail-safe retention period is how many days?

（A）1 day

（B）45 days

（C）7 days

（D）90 days

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 12

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

（A）Micro-partitions have been reclustered since the query was last run

（B）The user has the appropriate privileges on the objects associated with the query

（C）The query has been run within 24 hours of the previously-run query

（D）The new query is run using the same virtual warehouse as the previous query

（E）The query includes a User Defined Function (UDF)

正解：B、C 解答を投票する

質問 13

Which of the following statement is true of Snowflake?
Select one.

（A）It's based on an Oracle Architecture

（B）it was built as an on-premises solution and then potted to the cloud

（C）It was built for Hadoop architecture

（D）It was built specifically for the cloud

（E）It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

正解：D 解答を投票する

質問 14

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

（A）False

（B）True

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 15

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

（A）The size of the virtual warehouse

（B）The number of active users assigned to the warehouse

（C）The length of time the warehouse is running

（D）The duration of the queries that are executed

（E）The number of queries executed

正解：C、E 解答を投票する

質問 16

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

（A）Tri-Secret Secure

（B）External stages

（C）Fail-safe

（D）Data encryption

（E）Time Travel

正解：C、E 解答を投票する

質問 17

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

（A）Migrate some queries to a new warehouse to reduce load

（B）Scale up the warehouse size to allow Queries to execute faster.

（C）Use multi-clustered warehousing to scale out warehouse capacity.

（D）Stop and start the warehouse to clear the queued queries

（E）Limit user access to the warehouse so fewer queries are run against it.

正解：A、C 解答を投票する

質問 18

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

（A）SHOW STORAGE BY TABLE;

（B）Information Schema -> TABLE_HISTORY

（C）SHOW TABLES;

（D）Information Schema -> TABLE_FUNCTION

（E）Information Schema -> TABLE_STORAGE_METRICS

正解：A、E 解答を投票する

質問 19

What privilege should a user be granted to change permissions for new objects in a managed access schema?

（A）Grant ALL privileges on the schema.

（B）Grant the MANAGE GRANTS global privilege.

（C）Grant the OWNERSHIP privilege on the database.

（D）Grant the OWNERSHIP privilege on the schema.

正解：B 解答を投票する

COF-R02 無料問題集「Snowflake SnowPro Core Recertification」

弊社を連絡する

関連リンク

トップ試験