Snowflake SnowPro-Core 問題集

質問 1：
What are benefits of using Snowpark with Snowflake? (Select TWO).
A. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).
B. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
C. Snowpark does not require that a separate cluster be running outside of Snowflake.
D. Snowpark uses a Spark engine to generate optimized SQL query plans.
E. Snowpark automatically sets up Spark within Snowflake virtual warehouses.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
A. flatten
B. json_extract_path_text()
C. parse_json()
D. object_construct()
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
A. The columns with very high cardinality.
B. The columns with many different values.
C. The columns that are queried in the select clause.
D. The columns most actively used in the select filters.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?
A. The file loading could be aborted without any portion of the file being committed.
B. The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake
C. The tile will slop loading and all data up to that point will be committed.
D. The file will continue to load until all contents arc loaded.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
What is the purpose of multi-cluster virtual warehouses?
A. To create separate data warehouses to increase query optimization
B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
C. To allow the warehouse to resize automatically
D. To eliminate or reduce Queuing of concurrent queries
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
What is a key feature of Snowflake architecture?
A. Software updates are automatically applied on a quarterly basis
B. Zero-copy cloning creates a mirror copy of a database that updates with the original
C. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
D. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
E. Snowflake eliminates resource contention with its virtual warehouse implementation
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
A. NUMBER
B. OBJECT
C. STRING
D. VARCHAR
E. VARIANT
正解：B,E
解説: (Topexam メンバーにのみ表示されます)