AMAADOR ACADEMYالشهاداتالتحقق من شهادة

DP600

الاختبار النهائي — التحضير لامتحان Microsoft Fabric Analytics Engineer Associate (DP‑600)

أجب عن الأسئلة الـ48. تحتاج إلى 80% أو أكثر للنجاح. يمكنك إعادة المحاولة كلما أردت.

هذا الاختبار النهائي متاح بـالإنجليزية.

ادرس الدورة ←

السؤال 1According to the Microsoft Learn study guide, which DP-600 domain carries the largest weight?
السؤال 2What score is required to pass DP-600?
السؤال 3A finance team of SQL developers must build a gold layer where they run UPDATE and DELETE statements and multi-table transactions in T-SQL. Which Fabric item fits best?
السؤال 4Data scientists in Rabat receive JSON and CSV files daily and want to clean them with PySpark notebooks before loading Delta tables. Which store should they land the files in?
السؤال 5In what format do lakehouse and warehouse tables store their data in OneLake?
السؤال 6A candidate's preferred language is not available for DP-600. What can the candidate request according to the study guide?
السؤال 7A developer must create and edit notebooks and reports in a workspace but must not share items or add people. Which workspace role should you assign?
السؤال 8An auditor must run T-SQL queries against one warehouse but must not see any other item in the workspace. What should you do?
السؤال 9In a Fabric warehouse, each regional manager must see only rows for their own region in dbo.Sales. Which approach implements this?
السؤال 10A semantic model has a dynamic RLS role. A user who is a Member of the workspace reports that she sees all rows. Why?
السؤال 11Who can mark a semantic model as Certified?
السؤال 12HR wants salary data to stay marked Highly Confidential when a report built on the model is exported to Excel. What should you use?
السؤال 13Why save a Power BI report as a .pbip project instead of a .pbix file when using Git?
السؤال 14A team wants every change in its development workspace tracked in Azure DevOps and the ability to roll back. What should the analytics engineer configure first?
السؤال 15An engineer plans to drop a column from a lakehouse table. Which tool shows which semantic models and reports in other workspaces depend on that lakehouse?
السؤال 16You try to deploy a model change with Tabular Editor through the XMLA endpoint and get an error that the endpoint is read-only. What must change?
السؤال 17Which file opens Power BI Desktop already connected to a specific data source, without any report or model?
السؤال 18Ten departments build their own reports with copies of the same sales measures, and totals differ. What reusable asset best solves this?
السؤال 19An operational Azure SQL Database must be available in OneLake as Delta tables, kept in sync in near real time, with no pipeline to maintain. What should you use?
السؤال 20Business analysts who know Power Query must load and lightly reshape an Excel file from SharePoint into a warehouse table every day. Which item fits?
السؤال 21Where do you browse eventstreams, KQL tables and Azure event sources available to you in Fabric?
السؤال 22Before building a new product table, an analyst wants to find any existing certified product data in the tenant that she can access. Where should she look?
السؤال 23An eventhouse holds IoT data. Data engineers want to read the same tables from a lakehouse with Spark without copying them. What should you enable?
السؤال 24A source database sits on a server inside a company data centre with no public access. What does a Fabric pipeline or dataflow need to reach it?
السؤال 25After joining FactSales to DimProduct on ProductCode, total sales doubled for some products. What is the most likely cause?
السؤال 26Some sales rows reference a CustomerKey that does not exist yet in DimCustomer. Reports must still show their revenue in totals. What should the load do?
السؤال 27Which T-SQL function converts a text column to a date and returns NULL instead of an error for invalid values?
السؤال 28A lakehouse has Product, ProductSubcategory and ProductCategory tables. The semantic model should have one product table. What should you do in the gold layer?
السؤال 29A SQL team needs a reusable, parameterized query in the warehouse that returns orders for a given country, usable in a FROM clause. What should they create?
السؤال 30In a star schema, what does a fact table mainly contain?
السؤال 31You need product categories whose total 2026 sales exceed 1 million. Where does the condition on total sales belong in the T-SQL query?
السؤال 32In an eventhouse, you must count error events per device in 15-minute buckets over the last day. Which KQL fits?
السؤال 33Which keyword must every DAX query contain to return a table?
السؤال 34A business user who does not write SQL must join two warehouse tables, group by region and save the result for others to reuse. What should she use?
السؤال 35In the warehouse SalesDW you need to join dbo.Orders with the Customers table of the lakehouse CRM_LH in the same workspace. How do you reference it?
السؤال 36In KQL, which operator compares strings without regard to case?
السؤال 37A model has a 2-billion-row fact table in DirectQuery and small dimension tables also used by an Import aggregation table. Which storage mode should the dimensions use?
السؤال 38A bank account can belong to several customers, and a customer can hold several accounts. Transactions relate to accounts. How should you model customer analysis of transactions?
السؤال 39Sales has OrderDateKey and ShipDateKey, both related to Date. Order date is active. Which measure returns sales by ship date?
السؤال 40Which feature lets report users switch the measure shown in a visual between Revenue, Margin and Units through a slicer?
السؤال 41A measure must show the selected country's currency symbol: MAD for Morocco, EUR for France, SAR for Saudi Arabia, using one measure. What should you configure?
السؤال 42A measure must rank products by sales within the current category filter. Which function family does this need?
السؤال 43A Direct Lake on SQL analytics endpoint model reads a warehouse where RLS is defined with a security policy. What happens to user queries?
السؤال 44A nightly pipeline loads five gold tables one after another. Users sometimes see new sales with old products during the load. How do you make the Direct Lake model show all new data at once?
السؤال 45Which Direct Lake option can use tables from several Fabric items and never falls back to DirectQuery?
السؤال 46You set up incremental refresh on an import table. Which filter on OrderDate avoids loading boundary rows twice?
السؤال 47Performance analyzer shows a matrix visual with 9 seconds of DAX query time and 0.3 seconds of visual display. Where should you focus first?
السؤال 48Which DAX change usually improves performance and readability when the same expression is used three times in a measure?