CDP Data Analyst 試験対策問題集

模擬試験モードの設定

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

出題分野

• Cloudera Data Visualizations and Data Warehouse（可視化とウェアハウス）（出題比率 20%）
• Use Apache Hive and Impala（表の把握・型変換・結合・キー）（出題比率 20%）
• Apache Ranger and Atlas / Data Management and Storage（統制と格納）（出題比率 20%）
• Use Apache Hive and Impala SQL（表とビューの作成）（出題比率 8%）
• Calculate aggregate statistics（集計関数の利用）（出題比率 20%）
• Hive and Impala Optimization（押し下げ・bucketing・形式・統計）（出題比率 12%）

フリー問題

1. What does a Database Catalog in Cloudera Data Warehouse contain?
2. A team deletes a Virtual Warehouse after finishing a project. What happens to th…
3. An analyst adds one field to the Filters shelf of a single visual that sits insi…
4. In a Bars visual, which kinds of fields belong on the Colors shelf and on the To…
5. Which command tells an analyst whether a table is external, and which file forma…
6. A query joins two tables on columns that carry identical names. What does the US…
7. A query passes a BIGINT column to a function that expects INT. What does Impala …
8. An analyst must find which stored objects in a database hold order data, and whi…
9. New date directories were copied under a partitioned table but no query returns …
10. Where does Apache Atlas get the lineage that links an output column back to its …
11. How does HDFS lay out one large table file across the cluster?
12. One group is denied a database while a single member of that group must still re…
13. An analyst creates a view over a heavy join. What does the created view keep?
14. Which statement produces an empty table that carries the same columns as an exis…
15. One column holds NULL in some rows. How does COUNT over that column differ from …
16. Which values does the WHERE clause see, and which values does the HAVING clause …
17. A report needs each order row together with the running total for its customer. …
18. A sum over an order table joined to a shipment table returns twice the expected …
19. Two compression choices are available for a columnar table. What is the trade-of…
20. A wide table is queried for a few columns out of two hundred. Which storage choi…