Snowflake DAA-C01 問題集

質問 1：
A single variant data column table RAW_SOURCE has the following JSON records:

A Data Analyst needs to get the value of the "f" field and have it in a consumable, tabular format. Which query should be used to meet this requirement?
A. select src.events:f::number from raw_source src;
B. select data:events:f::number from raw_source;
C. select value:f::number from raw_source, lateral flatten( input => data );
D. select value:f::number from raw_source, lateral flatten( input => data:events );
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A Data Analyst created two tables that are related by a foreign key, using the following commands:

Then the Analyst renamed the referenced table using the following command: ALTER TABLE mother RENAME TO father; What happens to the foreign key after the referenced table is renamed?
A. The foreign key will not be used during the query rewrite.
B. The foreign key is dropped because the reference is no longer valid.
C. The foreign key is updated to reference the renamed table.
D. The foreign key becomes invalid because the referenced table no longer exists.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A Data Analyst created a SQL statement that updates a table used for reporting. The Analyst now wants to automate the execution of that SQL.
The Analyst decides to use a task for this along with a stream called MYSTREAM on the source table so only they can update the table if there is new data.
Which statement will create a task that will execute when there is new data in MYSTREAM without having to be executed manually?
A.

B.

C.

D.

正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A Data Analyst executes a complex query. Which query will allow the Analyst to access the results a second time?
A. SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
B. DESC RESULT LAST_QUERY_ID();
C. SELECT LAST_QUERY_ID(-1);
D. SELECT * FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY());
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
There are two similarly-structured and sized tables, Table_a and Table_b, in a schema with data populated in both tables. A Data Analyst is running queries as part of a preliminary analysis of the data to check the MAX value of a numeric column named num which is present in both the tables:
* Query 1: SELECT MAX(num) FROM Table_a;
* Query 2: SELECT MAX(num) FROM Table_b;
After running the queries, the Analyst observed that Query 2 ran significantly slower than Query 1. Why is this occurring?
A. The USE_CACHED_RESULT was set to FALSE before running Query 2.
B. Table_b has more rows than Table_a.
C. A multi-cluster warehouse was used to run Query 1.
D. Table_b has a row-access policy defined.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A Data Analyst has been analyzing customer data in several worksheets. Each worksheet contains a complex query that provides clean and prepared data for visualizations. The Analyst has also created a Customer Overview dashboard in Snowsight. How should the Analyst add the worksheets in the Customer Analysis database to the dashboard, using the LEAST amount of operational overhead?
A. Query the QUERY_HISTORY view to find those queries, then add the queries into the dashboard.
B. Open each worksheet, copy the query, then paste the query into the dashboard.
C. Copy and paste the worksheets into the dashboard.
D. Move the worksheets into the dashboard.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
A Data Analyst wants to use pandas code they have previously written to process a column of text and return multiple rows of parsed output for each input value. The Analyst wants to be able to join these results with other tables in a single transaction. Which type of extensibility feature should the Analyst use?
A. User-Defined Function (UDF)
B. Vectorized User-Defined Table Function (UDTF)
C. Stored procedure
D. External function
正解：B
解説: (Topexam メンバーにのみ表示されます)