SnowPro Advanced: Data Analyst 試験対策問題集

模擬試験モードの設定

上記は本サイトの模擬試験モードの設定値です。実際の試験の出題数・制限時間・合格基準は、各認定プログラムの公式サイトでご確認ください。

出題分野

• 1.0 Data Ingestion and Data Preparation（取り込みと準備）（出題比率 17%）
• 2.0 Data Transformation and Data Modeling（変換とモデリング）（出題比率 23%）
• 3.0 Data Analysis（データ分析）（出題比率 32%）
• 4.0 Data Presentation and Data Visualization（提示と可視化）（出題比率 28%）

フリー問題

1. A data analyst adds a PRIMARY KEY on the customer_id column of a dimension table…
2. A retail analytics team receives one daily sales file per store as a gzip-compre…
3. An analyst is asked to load a set of JSON files that arrive with a different set…
4. A large fact table is usually filtered by event_date. The query profile shows th…
5. A BI tool will connect to Snowflake and let business users drag dimensions onto …
6. A staging table contains multiple versions of each customer record, one per extr…
7. An analyst reports that the average order value for a region is higher than expe…
8. An events table has a VARIANT column named payload. Each document holds a top-le…
9. Two reports disagree on the number of active customers for the same month. Both …
10. A geospatial helper must accept a bounding box and return every monitoring stati…
11. A cohort analysis shows that customers acquired in March retain far better than …
12. A stored procedure orchestrates five independent refresh statements that each ta…
13. A monthly revenue distribution is strongly right-skewed because a handful of ent…
14. A weekly summary must show total sales for the current week and the same figure …
15. A dashboard must be refreshed every weekday at 7 am so that it is ready before t…
16. A tile must compare the number of support tickets across 8 product categories fo…
17. A dashboard must be usable by both the analytics team and the sales leadership. …
18. A weekly summary must reach 30 stakeholders by email every Monday at 8 am, inclu…
19. An analyst opens a new worksheet and runs a query that references a table by its…
20. An analyst is deciding which chart type to use for a tile that must show how mon…