COF-C02無料問題集「Snowflake SnowPro Core Certification」

質問 1

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

（A）Use the standard warehouse scaling policy

（B）Set the minimum and maximum clusters to autoscale

（C）Configure the warehouse to a size larger than generally required

（D）Use the economy warehouse scaling policy

正解：C 解答を投票する

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

質問 2

The Snowflake Search Optimization Services supports improved performance of which kind of query?

（A）Queries against tables larger than 1 TB

（B）Queries against large tables where frequent DML occurs

（C）Selective point lookup queries

（D）Queries against a subset of columns in a table

正解：C 解答を投票する

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

質問 3

What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).

（A）DELETE

（B）TRUNCATE

（C）UPSERT

（D）INSERT

（E）UPDATE

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

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

質問 4

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

（A）Query execution

（B）Authentication

（C）Data storage

（D）Metadata

（E）Compute resources

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

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

質問 5

Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

（A）NOTIF

（B）SUSPEND_IMMEDIATE

（C）SUSPEND

（D）NOTIFY_USERS

正解：B 解答を投票する

質問 6

What AUTHENTICATION_METHODS value should be selected for the Single Sign-On, or SSO, login option to appear when creating a Snowflake authentication policy?

（A）OAUTH

（B）KEYPAIR

（C）SAML

（D）PASSWORD

正解：C 解答を投票する

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

質問 7

At what levels can a network policy be configured in Snowflake? (Select TWO).

（A）User level

（B）Account level

（C）Role level

（D）Database level

（E）Virtual warehouse level

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

質問 8

How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column ID_NUMER?

（A）TRUNC (ID_NUMBER, -6)

（B）ID_NUMBER*100

（C）TRUNC (ID_NUMBER, 5)

（D）TO CHAR(ID_NUMBER)

正解：A 解答を投票する

質問 9

Which REST API can be used with unstructured data?

（A）loadHistoryScan

（B）insertReport

（C）inscrtFilcs

（D）GET /api/tiles/

正解：D 解答を投票する

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

質問 10

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

（A）Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.

（B）Reorder the data columns according to a target table definition and then unload the rows into the table.

（C）Reorder the rows in a relational table and then unload the rows into a file

（D）Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

正解：A 解答を投票する

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

質問 11

Which transformation is supported by a COPY INTO < table > command?

（A）Filter using a limit keyword

（B）Filter using a where clause

（C）Cast using a SELECT statement

（D）Order using an ORDER BY clause

正解：C 解答を投票する

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

質問 12

Will data cached in a warehouse be lost when the warehouse is resized?

（A）Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

（B）No. because the size of the cache is independent from the warehouse size

（C）Yes. became the new compute resource will no longer have access to the cache encryption key

（D）Yes. because the compute resource is replaced in its entirety with a new compute resource.

正解：B 解答を投票する

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

質問 13

What virtual warehouse feature or setting will reduce the performance impact when running larger-than- average queries by offloading portions of the query processing work to shared compute resources?

（A）Using the search optimization service

（B）Using a multi-cluster virtual warehouse

（C）Disabling auto-suspend

（D）Using the query acceleration service

正解：D 解答を投票する

質問 14

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

（A）False

（B）True

正解：B 解答を投票する

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

質問 15

Which Snowflake tool or feature enables governed sharing of datasets with a selected group of consumers that are invited, internal or external, to a Snowflake user ' s company?

（A）Data Exchange

（B）Snowflake Marketplace

（C）Snowpipe

（D）Replication

正解：A 解答を投票する

COF-C02 無料問題集「Snowflake SnowPro Core Certification」

弊社を連絡する

関連リンク

トップ試験