Prepare data Questions
Practice questions for Prepare data topic in Microsoft Certified: Fabric Analytics Engineer Associate. 87 questions covering this domain.
A Delta table is placed in the managed `Tables` area of a lakehouse. What does Fabric do automatically?
A modeler stores customer names, addresses, and other descriptive attributes in a separate table to reduce repeated text in a large sales table. What ...
A team needs a temporary table that aligns with normal user tables and supports unlimited storage and T-SQL operations in Fabric warehouse. Which choi...
What is the write capability of a lakehouse SQL analytics endpoint?
A lakehouse contains Parquet files in the Files area, and analysts want to query them through the lakehouse SQL analytics endpoint. What must happen f...
A data engineering team primarily uses Spark and needs to work with structured and unstructured data in one place. Which Fabric item should they choos...
A new warehouse is created in a workspace with the default collation settings. Which collation should the team expect, and can it be changed later?
A team must perform T-SQL DML against curated tables, use multi-table transactions, and keep a SQL-first development workflow. Which design best meets...
A team wants to add reusable T-SQL business logic on top of lakehouse Delta tables without moving the data into a warehouse. Which Fabric capability s...
A solution requires multi-table ACID transactions. Which statement is true when choosing between warehouse and lakehouse?
A warehouse load completed successfully, but query performance is poor on recently changed columns. Which statement about Fabric warehouse statistics ...
A Fabric administrator creates a new lakehouse in 2026 and expects a default semantic model to be created automatically. What should the administrator...
In a star schema, which type of table typically stores measurable business events such as orders, sales, or clicks?
A team wants full T-SQL support and multi-table transactional capabilities for curated structured data. Which Fabric item is the better fit?
Which table feature is currently not supported in Fabric warehouse?
A developer creates `#SalesStage` in a Fabric warehouse session to hold intermediate results. How long does that temp table exist?
A data architect wants to declare relational constraints in a Fabric warehouse. Which combination is supported?
A Fabric warehouse contains more than 750,000 objects. What documented behavior should the team expect for metadata handling?
Which table format appears and can be queried through a lakehouse SQL analytics endpoint?
A warehouse design includes a table used only to land and clean source data before inserting it into production fact and dimension tables. What catego...
Sign in to see all 87 questions
Create a free account to browse all questions — completely free during our launch phase.