最新のDAA-C01問題集で試験を準備する

Snowflake DAA-C01 試験概要:

Snowflake DAA-C01 試験シラバストピック:

Snowflake SnowPro Advanced: Data Analyst Certification 認定 DAA-C01 試験問題：

1. A Data Analyst executes a query in a Snowflake worksheet that returns the total number of daily sales, and the total amount for each sale. How can the Analyst check the distribution of the total amount, without running the query again?

A) Click on the column header in the results and review the histogram.
B) Call the WIDTH_BUCKET function.
C) Go to Chart and select a bar chart that contains the two variables.
D) Go to Chart and select a histogram that includes the two variables.

2. A Data Analyst needs a sample of 10 rows from a table FCT_SALES that has billions of rows. Which commands can be used to accomplish this? (Select TWO).

A) SELECT TOP 10 ROWS * FROM FCT_SALES;
B) SELECT * FROM FCT_SALES SAMPLE (10 ROWS);
C) SELECT TOP 10 * FROM FCT_SALES;
D) SELECT * FROM FCT_SALES SAMPLE 10;
E) SELECT TOP (10 ROWS) * FROM FCT_SALES;

3. A Data Analyst creates a dashboard showing the total credit consumption for each virtual warehouse as follows:

Why is the query failing?

A) DB1 must be authorized to have SELECT access to ACCOUNT_USAGE.
B) INFORMATION_SCHEMA should be used instead of ACCOUNT_USAGE.
C) The query must be executed by a user with the ACCOUNTADMIN role.
D) The current database context must be changed to SNOWFLAKE.

4. A large, complicated query is used to generate a data set for a report on the most recent month. It is taking longer than expected. A review of the Query Profile shows excessive spilling. How can the performance of the query be improved WITHOUT increasing costs?

A) Change the source tables into external tables to establish and take advantage of custom partitioning.
B) Run the query against zero-copy clones of the source tables to avoid contention with other queries.
C) Create a materialized view clustered on a date column, on the table that is causing the spilling.
D) Split the query into multiple steps, replacing Common Table Expressions (CTEs) with temporary tables to process the data in smaller batches.

5. A Data Analyst needs to temporarily hide a tile in a dashboard. The data will need to be available in the future, and additional data may be added. Which tile should be used?

A) Delete
B) Unplace
C) Show/Hide
D) Duplicate

質問と回答：