Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Freddie Mac Data Analyst Interview Questions

The questions to prepare for a Freddie Mac Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

50questions
~8htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions · ~94 min
SQL Duplicate DetectionEasy
Practice

Find duplicate customer profiles by grouping on identifying fields and returning only repeated records.

Group ByHavingAggregationsFreddie Mac
Rank Employees Within DepartmentsEasy
Practice

Rank active Revature employees within each department using RANK and a department join.

Window FunctionsJoinsRankingFreddie Mac
More SQL & Data Manipulation questions with a free account
2
A/B Testing & Experimentation5 questions · ~47 min
Design Test for New FeatureMedium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B TestingFreddie Mac
Handle Peeking in Customer ExperimentsHard

Decide how to analyze an experiment when results are checked repeatedly and multiple comparisons may inflate false positives.

PeekingExperimentationStatistical SignificanceFreddie Mac
More A/B Testing & Experimentation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Product Sense3 questions · ~28 min
Align Product With User NeedsMedium

A framework for connecting user needs to business goals, then making product decisions with clear trade-offs and measurable outcomes.

User NeedsValue PropositionProduct VisionFreddie Mac
More Product Sense questions with a free account
4
Pipelines10 questions · ~94 min
Batch vs Streaming Data ProcessingEasy

Compare batch and streaming data processing, including when each fits best in a pipeline.

Stream ProcessingETLBatch ProcessingFreddie Mac
More Pipelines questions with a free account
5
Statistics & Probability10 questions · ~94 min
Understanding Type I and Type II Errors in TestingMedium

Differentiate between Type I and Type II errors in hypothesis testing with a practical example.

Hypothesis TestingStatistical SignificanceP-ValuesFreddie Mac
More Statistics & Probability questions with a free account
6
Metrics10 questions · ~94 min
Define a Product North StarMedium

Define a North Star Metric for a product and explain how it guides KPI selection and growth decisions.

User SegmentsNorth Star MetricKPIsFreddie Mac
More Metrics questions with a free account
7
More topics2 questions · ~19 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.