Snowflake SnowPro-Core 問題集

質問 1：
How would a user execute a series of SQL statements using a task?
A. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
B. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..
C. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
D. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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_STORAGE_METRICS
C. Information Schema -> TABLE_HISTORY
D. SHOW TABLES;
E. Information Schema -> TABLE_FUNCTION
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
The following settings are configured:

For how many days will the data be retained at the object level?
A. 2
B. 3
C. 7
D. 5
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which file format will keep floating-point numbers from being truncated when data is unloaded?
A. ORC
B. CSV
C. JSON
D. Parquet
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
A. The default virtual warehouse will be used to read all data.
B. The virtual warehouse that is defined at the session level will be used to read all data.
C. No virtual warehouse will be used, data will be read from the result cache.
D. No virtual warehouse will be used, data will be read from the local disk cache.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which Snowflake command can be used to unload the result of a query to a single file?
A. Use COPY INTO <internal stage> followed by a put command to download the file.
B. Use COPY INTO <external stage> followed by a GET command to download the file.
C. Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.
D. Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?
A. A Scalar User Function (UDF)
B. A User-Defined Table Function (UDTF)
C. A task
D. A stored procedure
正解：B
解説: (Topexam メンバーにのみ表示されます)