Certified Retail Analyst (CRA) — Questions and Answers
Question 1: What does a Net Promoter Score (NPS) measure in retail?
- Customer willingness to recommend the retailer (Correct answer)
- Product return likelihood
- Average transaction frequency
- Inventory accuracy rate
Correct answer: Customer willingness to recommend the retailer
NPS gauges customer loyalty by asking how likely shoppers are to recommend the retailer to others, on a 0–10 scale.
Question 2: What role does supply chain management play in data management?
- Supply chain management relies on data for inventory optimization and delivery efficiency (Correct answer)
- Supply chain management is not affected by data management.
- Supply chain management reduces product quality.
- Supply chain management only applies to manufacturing.
Correct answer: Supply chain management relies on data for inventory optimization and delivery efficiency
Supply chain management heavily depends on accurate and timely data to function effectively. Data on inventory levels, order fulfillment, shipping logistics, and supplier performance is crucial for optimizing stock, minimizing lead times, and ensuring efficient delivery of products. Without robust data, supply chains would be inefficient, prone to disruptions, and unable to meet customer demands reliably.
Question 3: Price indexing against competitors involves calculating a ratio of your price to the competitor's price. A price index of 105 means:
- Your price is 5% higher than the competitor's price (Correct answer)
- Your price matches the competitor's price exactly
- Your product's quality score is 5 points above the competitor's
- Your price is 5% lower than the competitor's price
Correct answer: Your price is 5% higher than the competitor's price
A price index above 100 means the retailer's price is higher than the benchmark competitor's price by that percentage difference.
Question 4: A retail analyst is tasked with reducing SKU proliferation. What is the main benefit of this effort?
- Simplifying assortment to improve inventory efficiency and shopper clarity (Correct answer)
- Adding more promotional price points
- Increasing the number of vendor partnerships
- Expanding store square footage
Correct answer: Simplifying assortment to improve inventory efficiency and shopper clarity
Reducing SKU count focuses inventory investment on top-performing products, lowering complexity, improving turnover, and making shopping easier for consumers.
Question 5: What is 'dead stock' and why is it a financial concern for retailers?
- Clearance items priced below cost; they improve cash flow
- Products discontinued by vendors; they require sourcing alternatives
- Returned merchandise; it increases processing expenses
- Inventory that has not sold for an extended period; it ties up capital and incurs holding costs (Correct answer)
Correct answer: Inventory that has not sold for an extended period; it ties up capital and incurs holding costs
Dead stock is unsold inventory that consumes warehouse space and working capital without generating revenue, reducing overall financial performance.
Question 6: In Retail Link, what does a '0% In-Stock' reading on a store-item combination most likely indicate?
- The item had no on-hand inventory for the entire measurement period (Correct answer)
- The item had zero sales during that period
- The item was removed from the planogram
- The store did not transmit POS data for that week
Correct answer: The item had no on-hand inventory for the entire measurement period
A 0% In-Stock reading means the item recorded zero on-hand units throughout the entire measurement period, signifying a stockout.
Question 7: A supplier notices that Retail Link shows 'On Order' units for their item but On Hand has not increased after the expected delivery window. This discrepancy most likely indicates:
- Walmart cancelled the purchase order but Retail Link has a 48-hour update delay
- Retail Link rounds On Order units to the nearest case pack
- The shipment was received but not yet processed through the DC or store receiving system (Correct answer)
- The item was substituted for a different SKU during the pick process
Correct answer: The shipment was received but not yet processed through the DC or store receiving system
If On Order units exist but On Hand has not updated, the goods likely arrived but have not yet been scanned and processed through Walmart's receiving system.
Question 8: In voice-of-customer (VOC) programs, which data source provides the most direct consumer sentiment?
- Planogram compliance audits
- Customer surveys and reviews (Correct answer)
- Vendor scorecards
- Internal sales reports
Correct answer: Customer surveys and reviews
Customer surveys and reviews capture first-hand shopper opinions, making them the most direct source of voice-of-customer sentiment.
Question 9: In Retail Link, which metric specifically measures how efficiently an item converts its allocated shelf space into sales revenue?
- On Hand Turn Rate
- Sales per Linear Foot (Correct answer)
- Average Retail Price per Unit
- Vendor Fill Rate
Correct answer: Sales per Linear Foot
Sales per Linear Foot measures how much revenue an item generates relative to the shelf space it occupies, a key space productivity metric.
Question 10: What is the primary function of Retail Link Data Management?
- To manage and analyze sales, inventory, and supply chain data (Correct answer)
- To manage only customer data.
- To manage employee data.
- To oversee marketing campaigns.
Correct answer: To manage and analyze sales, inventory, and supply chain data
Retail Link Data Management refers to systems and processes used to collect, store, and analyze vast amounts of data generated within a retail environment, often specifically referring to Walmart's supplier portal. Its primary function is to provide comprehensive insights into sales performance, inventory levels, and supply chain efficiency. This enables better decision-making for both retailers and their suppliers.
Question 11: In retail, what does 'return on investment' (ROI) for a promotional event measure?
- Total units sold during the event
- Net profit generated by the promotion relative to its cost (Correct answer)
- Percentage increase in store traffic
- Number of new customers acquired
Correct answer: Net profit generated by the promotion relative to its cost
Promotional ROI compares the incremental net profit earned during a promotion to the cost of running it, expressed as a percentage.
Question 12: Which tool is commonly used by retail analysts to visualize customer journey touchpoints?
- Customer journey map (Correct answer)
- Fishbone diagram
- Gantt chart
- Kanban board
Correct answer: Customer journey map
A customer journey map visualizes all touchpoints a shopper experiences from awareness through purchase and post-sale service.
Question 13: A retailer's 'shrinkage' most commonly results from which combination of causes?
- Employee theft, shoplifting, vendor fraud, and administrative errors (Correct answer)
- High return rates and damaged goods
- Markdowns and overstock
- Seasonal demand fluctuations and poor forecasting
Correct answer: Employee theft, shoplifting, vendor fraud, and administrative errors
Retail shrinkage is the loss of inventory due to theft (internal and external), vendor fraud, and paperwork errors.
Question 14: A retail analyst reviews a dashboard showing 'session duration' and 'bounce rate.' What type of platform generates these metrics?
- Supply chain visibility tool
- Web analytics platform (e.g., Google Analytics) (Correct answer)
- Workforce scheduling software
- Inventory management system
Correct answer: Web analytics platform (e.g., Google Analytics)
Session duration and bounce rate are website traffic metrics tracked by web analytics platforms that measure how visitors interact with e-commerce sites.
Question 15: Which retail metric measures the percentage of store visitors who make a purchase?
- Sell-through rate
- Basket penetration
- Conversion rate (Correct answer)
- Traffic index
Correct answer: Conversion rate
Conversion rate is calculated as the number of transactions divided by the number of visitors to the store.
Question 16: A retailer's operating expense ratio increased while revenue was flat. What is the likely financial impact?
- Higher inventory turnover
- Reduced cost of goods sold
- Improved net income
- Compressed operating profit margins (Correct answer)
Correct answer: Compressed operating profit margins
When operating expenses grow as a share of flat revenue, operating profit margins shrink because costs are consuming more of each sales dollar.
Question 17: A supplier's item shows high POS sales but consistently low On Hand units in Retail Link. The most likely operational cause is:
- Replenishment orders are not being generated frequently enough to keep pace with velocity (Correct answer)
- Markdown pricing has temporarily inflated unit velocity
- Walmart buyers have reduced the item's authorized facing count
- The item's case pack size is too large for store backrooms
Correct answer: Replenishment orders are not being generated frequently enough to keep pace with velocity
When sales velocity outpaces replenishment frequency, on-hand inventory depletes quickly, indicating an under-replenishment issue.
Question 18: How do retailers use data to optimize customer experiences?
- Data does not impact customer experiences.
- Data helps retailers personalize experiences and build customer loyalty (Correct answer)
- Data only affects product pricing.
- Customer experiences are irrelevant to data management.
Correct answer: Data helps retailers personalize experiences and build customer loyalty
Retailers collect and analyze data on customer preferences, purchase history, and browsing behavior. This information allows them to personalize marketing messages, recommend relevant products, offer tailored promotions, and create customized shopping experiences. Personalization fosters a stronger connection with customers, enhancing satisfaction and building long-term loyalty, which is crucial for sustained business growth.
Question 19: What is the role of market research in retail strategy development?
- Market research provides insights into consumer needs and trends (Correct answer)
- Market research only applies to new product development.
- Market research is only used for advertising strategies.
- Market research is unnecessary for retail strategy development.
Correct answer: Market research provides insights into consumer needs and trends
Market research is the systematic gathering and analysis of information about consumers, competitors, and the market. In retail, it provides crucial insights into what customers want, identifies emerging trends, assesses market demand, and evaluates the effectiveness of existing strategies. These insights are indispensable for making informed decisions and developing successful, customer-centric retail strategies.
Question 20: A retailer's 'channel conflict' most commonly arises when:
- A brand sells directly to consumers, undercutting the retailer's pricing (Correct answer)
- A retailer expands into a new geographic market
- A store manager overrides corporate planogram guidelines
- Two product categories compete for the same shelf space
Correct answer: A brand sells directly to consumers, undercutting the retailer's pricing
Channel conflict occurs when a vendor's direct-to-consumer channel competes with retail partners, creating pricing and relationship tensions.
Question 21: A Retail Link user receives an 'Access Denied' error when attempting to run a report on a specific category. The most common reason is:
- The user's supplier account does not have authorization for items in that category (Correct answer)
- The report template requires a paid Retail Link Premium subscription
- The category was discontinued by Walmart and archived from Retail Link
- The category's data is under a 90-day embargo following a planogram reset
Correct answer: The user's supplier account does not have authorization for items in that category
Retail Link access is supplier-specific; users can only view data for categories and items their company is authorized to sell.
Question 22: Which financial metric shows how many times a retailer sells and replaces its inventory in a year?
- Debt-to-equity ratio
- Days sales outstanding
- Inventory turnover ratio (Correct answer)
- Current ratio
Correct answer: Inventory turnover ratio
Inventory turnover ratio equals COGS divided by average inventory and indicates how efficiently a retailer manages its stock.
Question 23: A retailer's gross margin is 42% and its operating expense ratio is 38%. What is its operating margin?
- 6%
- 80%
- 4% (Correct answer)
- 2%
Correct answer: 4%
Operating margin equals gross margin minus operating expense ratio: 42% - 38% = 4%.
Question 24: What is 'market basket analysis' used for in retail?
- Evaluating supplier performance
- Identifying products frequently purchased together (Correct answer)
- Measuring store square footage efficiency
- Forecasting seasonal demand peaks
Correct answer: Identifying products frequently purchased together
Market basket analysis mines transaction data to find product associations, informing cross-merchandising and promotional bundling strategies.
Question 25: What is the recommended approach when actual sell-through is significantly below the initial plan midway through a season?
- Increase future orders to recoup lost sales volume
- Wait until the season ends before making any plan adjustments
- Revise the open-to-buy downward and accelerate markdowns to manage end-of-season inventory risk (Correct answer)
- Maintain the original plan to avoid confusing vendors
Correct answer: Revise the open-to-buy downward and accelerate markdowns to manage end-of-season inventory risk
Reducing open-to-buy and accelerating markdowns mid-season limits inventory risk and prevents excess carryover that erodes margin.
Question 26: A store's same-store sales (SSS) increased 5% year-over-year. What does this indicate?
- Online sales grew 5%
- Total company sales grew 5%
- Five new store locations opened
- Existing store locations grew revenue by 5% (Correct answer)
Correct answer: Existing store locations grew revenue by 5%
Same-store sales (also called comparable-store sales) measures revenue growth at locations open for at least one year, excluding new stores.
Question 27: Which metric represents the proportion of a category's total available market that a specific retailer captures?
- Market penetration rate
- Category market share (Correct answer)
- Category conversion rate
- Share of wallet
Correct answer: Category market share
Category market share measures what percentage of total consumer spending in a product category flows to a specific retailer.
Question 28: When building a retail assortment plan, which analytical output should be reviewed to identify underperforming attributes?
- Attribute-level sales penetration and margin contribution analysis (Correct answer)
- Average unit retail price across all categories
- Total SKU count by vendor
- Year-over-year store count changes
Correct answer: Attribute-level sales penetration and margin contribution analysis
Attribute-level penetration and margin analysis reveals which product characteristics (size, color, brand) are driving or dragging category performance.
Question 29: When documenting activities related to technology & digital tools, which practice is considered essential for CRA certification holders?
- Completing documentation only when requested by auditors or supervisors
- Recording only outcomes while omitting the methods and processes used
- Maintaining comprehensive records that include procedures, observations, results, and any anomalies (Correct answer)
- Keeping documentation in personal notes that are not accessible to other team members
Correct answer: Maintaining comprehensive records that include procedures, observations, results, and any anomalies
Comprehensive documentation that includes procedures, observations, results, and any anomalies is essential in technology & digital tools. This supports quality assurance, enables peer review, and satisfies regulatory and audit requirements.
Question 30: When analysts refer to a retailer's 'assortment breadth,' they mean:
- The depth of inventory for a single category
- The number of units held per SKU
- The price range from lowest to highest SKU
- The total number of distinct product categories carried (Correct answer)
Correct answer: The total number of distinct product categories carried
Assortment breadth refers to the number of different product categories or lines a retailer offers, as opposed to depth which is the number of options within a category.
Question 31: Which segmentation approach groups customers by demographic attributes such as age and income?
- Behavioral segmentation
- Geographic segmentation
- Psychographic segmentation
- Demographic segmentation (Correct answer)
Correct answer: Demographic segmentation
Demographic segmentation categorizes customers using observable characteristics like age, gender, and income level.
Question 32: What is the primary purpose of A/B testing in retail analytics?
- Auditing two store locations simultaneously
- Testing two versions of an experience to determine which drives better outcomes (Correct answer)
- Comparing two supplier contracts
- Matching SKUs across two planograms
Correct answer: Testing two versions of an experience to determine which drives better outcomes
A/B testing exposes two customer groups to different experiences and measures which version achieves higher conversion, revenue, or engagement.
Certified Retail Analyst (CRA)
The CRA certification from Northwest Arkansas Community College validates proficiency in retail analytics, data management, and strategic analysis for suppliers and retailers working with data tools like Walmart's Retail Link. It covers retail fundamentals, supply chain, category management, consumer analytics, and financial metrics.
Exam Rules
- You can skip questions and return to them later
- Flag questions for review before submitting
- No feedback shown until you submit the entire exam
- Unanswered questions count as wrong — answer everything
- 10 pretest questions are mixed in and don't affect your score
- Timer auto-submits when time runs out
- Your progress is auto-saved every 30 seconds