18 real Power Query questions from the Power BI bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.
1. What is M language?
Junior
A.the case-sensitive functional formula language that records and powers data import and transformation logic
B.the distinction between a query that points at another query's output versus a standalone independent copy of its steps
C.the optimization where transformation logic is translated back into a native source query so work runs at the database instead of locally
D.a reusable cloud-stored ingestion artifact that runs Power Query online and saves results for multiple datasets to consume
A.Applied steps — the case-sensitive functional formula language that records and powers data import and transformation logic
B.Applied steps — the optimization where transformation logic is translated back into a native source query so work runs at the database instead of locally
C.Applied steps — the ordered, replayable list of transformations recorded for a query, each editable or removable individually
D.Applied steps — a transformation that turns columns into attribute-value row pairs to reshape wide data into a tall normalized layout
8. Which term means: "the optimization where transformation logic is translated back into a native source query so work runs at the database instead of locally"?
A.Query folding — a reusable cloud-stored ingestion artifact that runs Power Query online and saves results for multiple datasets to consume
B.Query folding — the optimization where transformation logic is translated back into a native source query so work runs at the database instead of locally
C.Query folding — the distinction between a query that points at another query's output versus a standalone independent copy of its steps
D.Query folding — a transformation that turns columns into attribute-value row pairs to reshape wide data into a tall normalized layout
A.Reference vs Duplicate — the optimization where transformation logic is translated back into a native source query so work runs at the database instead of locally
B.Reference vs Duplicate — the ordered, replayable list of transformations recorded for a query, each editable or removable individually
C.Reference vs Duplicate — a reusable cloud-stored ingestion artifact that runs Power Query online and saves results for multiple datasets to consume
D.Reference vs Duplicate — the distinction between a query that points at another query's output versus a standalone independent copy of its steps
Answers, AI explanations, and a scored voice mock interview
Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.