CIW DATA ANALYST
1D0-622 PRACTICE EXAM
48 QUESTIONS
Question 1: A retailer wants to understand why veteran store managers consistently outperform newer managers, but many of their practices are not documented.What should the analyst do �rst to capture this institutional knowledge?
Choices:
1) Interview the veteran managers and document their decision rules and practices 2) Delete existing performance data to avoid bias 3) Replace qualitative information with random samples 4) Move all sales records to a public data portal Correct Answer: Interview the veteran managers and document their decision rules and practices Explanation: Institutional or tribal knowledge often exists in employees' experience rather than formal systems. Structured interviews and documentation capture that knowledge so it can be analyzed alongside quantitative data.Page 1
Question 2: What is a primary analytical bene�t of centralizing customer, sales, and service data in one enterprise application?
Choices:
1) It guarantees that every source contains only structured data 2) It reduces data silos and supports a more consistent view of the customer 3) It eliminates the need for data governance 4) It prevents users from creating duplicate records under all circumstances Correct Answer: It reduces data silos and supports a more consistent view of the customer Explanation: Centralization can reduce isolated data silos and make records easier to reconcile across departments. It does not automatically eliminate governance needs or all duplication.
Question 3: Which example is unstructured data?
Choices:
1) A table of invoice numbers and payment dates 2) A spreadsheet column containing monthly unit sales 3) Free-form customer comments in a support forum 4) A relational table of product IDs and prices
Correct Answer: Free-form customer comments in a support forum
Explanation: Free-form forum comments do not follow a �xed row-and-column schema, so they are unstructured. The other examples have explicit �elds and are structured.Page 2
Question 4: An analyst needs evidence of which products generate the most
revenue by region. Which source is most directly useful?
Choices:
1) Employee vacation requests 2) Public weather forecasts 3) Website color-style guidelines 4) Sales transaction records containing product, amount, and region Correct Answer: Sales transaction records containing product, amount, and region Explanation: Sales transaction records directly contain the measures and dimensions needed to compare product revenue by region.Question 5: A company wants to evaluate whether its SEO e�orts are increasing discovery across several channels. Which measurement approach is best?
Choices:
1) Compare search visibility, referral tra�c, and conversions across relevant online channels over time 2) Track only the number of pages in the company's internal wiki 3) Measure only total payroll expense 4) Count every social-media follower as a completed sale Correct Answer: Compare search visibility, referral tra�c, and conversions across relevant online channels over time Explanation: SEO analysis should connect visibility and tra�c with meaningful outcomes across channels. Referral tra�c and conversions provide stronger evidence than unrelated counts or vanity metrics alone.Page 3