AMAADOR ACADEMYCertificatesVerify a certificate

DP700

Final check — Microsoft Fabric Data Engineer Associate (DP-700) Exam Prep

Answer the 47 questions. You need 80% or more to pass. You can retry as many times as you like.

Study the course →

Question 1Which statement about DP-700 scoring is confirmed by Microsoft Learn?
Question 2How are the three DP-700 domains weighted in the current study guide?
Question 3Twelve analysts run short notebooks from the same pipeline many times a day. Each notebook waits for its own Spark session to start. What setting reduces this start-up time?
Question 4Your company wants Finance and Sales to manage their own workspaces' settings and let users filter the OneLake catalog by business area. What should the Fabric admin set up?
Question 5A lakehouse uses Amazon S3 shortcuts. Analysts read the same files many times a day and the cloud egress bill is rising. Which workspace setting helps most?
Question 6What is an environment item used for in Fabric data engineering?
Question 7A developer connected a workspace to an Azure DevOps branch. A colleague's pull request has just been merged into that branch. How does the workspace get the new item definitions?
Question 8After a deployment from Test to Production, the lakehouse in Production has the new table schema in its definition but no rows. What explains this?
Question 9What does building a SQL database project produce for a Fabric warehouse?
Question 10Two developers must change the same notebooks for a month-long feature without disturbing the shared Dev workspace linked to main. What is the recommended approach?
Question 11In a deployment pipeline, what does the Compare feature show?
Question 12Your warehouse team wants a pull request to fail if a view references a column that was dropped. Which practice gives this check?
Question 13A partner analyst needs to query one warehouse with T-SQL. Nothing else in the workspace should be visible to them. What should you grant?
Question 14Sales managers must see only rows for their own region in a warehouse FactSales table, whatever tool they query from. What do you implement?
Question 15Which T-SQL statement implements column-level security in a Fabric warehouse?
Question 16A support team must see only the last four digits of customer phone numbers in query results. The stored data must not change. What should you use?
Question 17Who can mark a Fabric item as Certified?
Question 18Data scientists read lakehouse files from notebooks. They must read only the /Files/marketing folder, not /Files/hr. What do you configure?
Question 19You must copy 40 tables from an on-premises SQL Server every night, then run one PySpark notebook that builds gold tables, and email the team on failure. What is the best design?
Question 20Inside a ForEach activity, which expression returns the TableName field of the current element?
Question 21A pipeline Notebook activity passes run_date = 2026-11-01, but the notebook still uses its default date. What is the most likely cause?
Question 22A main notebook must run five independent cleanup notebooks at the same time, then a sixth that depends on all five, in one Spark session. What should you use?
Question 23What is the difference between a pipeline parameter and a pipeline variable?
Question 24A pipeline must write each day's extract to a folder like raw/2026/11/18. Which dynamic content builds the path?
Question 25A source table has a reliable LastModified column. Rows are sometimes deleted at the source, and the lakehouse copy must reflect deletes. Which approach meets this?
Question 26A fact row arrives with CustomerKey 'C-998' that does not exist yet in DimCustomer. The customer record will arrive tomorrow. What should the load do?
Question 27Which slowly changing dimension type keeps history by adding a new row with validity dates?
Question 28An operational Azure SQL Database must be available in OneLake within minutes of each change, for analytics only, with minimal pipeline code to maintain. What should you use?
Question 29A team of SQL developers needs multi-table transactions, UPDATE and DELETE statements and stored procedures for a curated sales model. Which store fits best?
Question 30You create a shortcut in a lakehouse Tables folder to an ADLS Gen2 folder of CSV files. The shortcut does not show up as a table. Why?
Question 31This PySpark code should return total sales per region, but regions with no matching dimension rows disappear: sales.join(dim_region, 'RegionId').groupBy('RegionName').sum('Amount'). What is the fix?
Question 32Which KQL query returns the latest record for each DeviceId?
Question 33A Product dimension is stored as Product, Subcategory and Category tables. Report authors complain about too many joins. What should the gold layer do?
Question 34A Dataflow Gen2 fails when loading a CSV column Amount because a few rows contain the text 'n/a'. The business wants those rows kept with a zero amount. What should you do?
Question 35In a Fabric warehouse, which statement creates and fills a new aggregated table in one step?
Question 36A team needs to filter IoT events from Azure IoT Hub, send critical ones to an alert and store all events for KQL analysis, without writing code. What should they build?
Question 37A structured streaming query writing to a Delta table was restarted after a failure and reprocessed all events from the beginning. What was most likely missing?
Question 38What does this Spark code produce: groupBy(window('ts', '10 minutes'), 'machine').avg('temp')?
Question 39Security wants an alert when a user has 5 failed sign-ins within any 2-minute period, evaluated as events arrive. Which window type matches this rule best?
Question 40In an eventhouse, what does an update policy do?
Question 41A Spark streaming aggregation by 5-minute window keeps growing in memory because state for old windows is never dropped. Events can arrive up to 10 minutes late. What should you add?
Question 42A pipeline failed overnight. You must find which activity failed and read its error message. Where do you start?
Question 43In the Spark UI, one task in a join stage runs for 40 minutes while the other 199 finish in under a minute. What is the most likely issue and fix?
Question 44A warehouse load inserts 2 million rows one at a time with INSERT ... VALUES inside a loop and takes hours. What should you change?
Question 45Which eventhouse setting keeps the last 30 days of a table on fast local storage for queries?
Question 46An eventhouse table receives events, but a new JSON field is not landing in its column and some rows are rejected. Which command helps you see why?
Question 47Which statement about V-Order in Fabric is correct?