Snowflake SnowPro-Core 問題集

質問 1：
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
A. Share the worksheet with teammates within Snowsight
B. Create a private Data Exchange so that any teammate can use the worksheet
C. Create a database and grant all permissions to teammates
D. Create a zero-copy clone of the worksheet and grant permissions to teammates
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
What is the recommended way to change the existing file format type in my format from CSV to JSON?
A. ALTER FILE FORMAT my_format SET TYPE=JSON;
B. REPLACE FILE FORMAT my format TYPE-JSON;
C. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
D. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?
A. PURGE
B. REMOVE
C. DELETE
D. MODIFY
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which semi-structured file format is a compressed, efficient, columnar data representation?
A. Avro
B. TSV
C. JSON
D. Parquet
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which command is used to unload files from an internal or external stage to a local file system?
A. GET
B. PUT
C. TRANSFER
D. COPY INTO
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which statement MOST accurately describes clustering in Snowflake?
A. The clustering key must be included in the COPY command when loading data into Snowflake.
B. Clustering can be disabled within a Snowflake account.
C. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
D. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
A. Query computation
B. Metadata management
C. Data storage
D. Security
E. Data visualization
正解：B,D
解説: (Topexam メンバーにのみ表示されます)