Microsoft Certified: Fabric Analytics Engineer Associate - Full Practice Exam 1

1. A business analyst needs to discover approved data assets across the organization before creating another copy. Which starting point is most appropriate?
2. A calculation group contains prior-year and year-to-date items. What is its key reuse benefit?
3. A composite model combines imported dimensions with a DirectQuery fact table. What should be tested carefully?
4. A consultant needs one report, not access to every item in a Fabric workspace. Which approach best follows least privilege?
5. A DAX expression must calculate sales with all Product filters removed while preserving the current Date filter. Which form fits?
6. A DAX query must return a region-level summary of an existing [Sales] measure. Which function is designed for grouped model queries?
7. A Direct Lake on SQL analytics endpoint model uses a source feature that requires fallback. Why must the team inspect fallback behavior?
8. A Fabric deployment pipeline promotes analytics content from development to production. Which checks are necessary? Select 2 answers.
9. A Fabric model needs low-latency analytical access to supported Delta tables in OneLake without conventional full data imports. Which mode should be evaluated?
10. A KQL Events table has Timestamp and Service. You need event counts by service for the last hour. Which query fits?
11. A KQL query should retain only Timestamp and DurationMs after filtering. Which operator is appropriate?
12. A large Import model should refresh only recent date partitions while retaining older history. Which feature fits?
13. A many-to-many customer-to-segment assignment must filter sales without duplicating sales amounts through a physical flattening join. What should be considered?
14. A measure repeats the same expensive scalar expression several times. What DAX technique can improve readability and avoid repeated evaluation within its context?
15. A product dimension uses a Type 1 update for a corrected spelling. What does this imply?
16. A reviewed semantic model should be identifiable as a trusted organizational source. Which capability should authorized reviewers use?
17. A Sales table has Amount values 10, NULL, and 30. What do COUNT(Amount) and COUNT(*) return respectively?
18. A semantic model grows beyond ordinary small-model requirements on a supported capacity. Which setting should the owner evaluate for large-scale storage and management?
19. A semantic model has two active filter routes from Customer to Sales. Combining segment and customer slicers produces surprising totals. What should be investigated?
20. A semantic model uses regional RLS. A tester validates only as workspace Admin and sees every region. What should change?
21. A slowly changing customer dimension must preserve the region applicable when each sale occurred. Which modeling approach fits?
22. A SQL query must retain rows whose CancellationDate is missing. Which predicate is appropriate?
23. A SQL table stores OrderDateTime but analysis needs daily sales totals. Which transformation is appropriate?
24. A star schema contains Sales facts and Product and Date dimensions. Why avoid storing independent dimension descriptions repeatedly in every fact row when unnecessary?
25. A streaming analytics team needs to discover available real-time event sources in Fabric. Which experience is intended for that purpose?
26. A supported capacity-backed semantic model must be managed through tabular tooling using XMLA. What configuration needs verification?
27. A team compares Direct Lake on OneLake with Direct Lake on a SQL analytics endpoint. Which assumption should it avoid?
28. A team labels a model Confidential. Why must it still configure access permissions?
29. A team needs a relational analytics store with T-SQL writes and multi-table transactional processing. Which Fabric item is the better fit?
30. A team needs Spark-based transformations on Delta data and a SQL read surface for analysts. Which Fabric item fits?
31. A team restores a prior Git revision of a supported Fabric item definition. Which statement is correct?
32. A team wants reusable report structure and queries without shipping imported business data to every new author. Which asset is appropriate?
33. A view applies a consistent rule excluding test transactions for several downstream queries. What is the main benefit?
34. A warehouse query must retain customers with no orders and show null order columns. Customers is the left table. Which join fits?
35. A warehouse view feeds several semantic models. Its owner plans to rename a field and change its type. What should be inspected first?
36. An Amount string column contains '12.50', '9.00', and 'unknown'. You need a numeric result and an exception list. Which approach is appropriate?
37. An analytics team wants text-based Power BI report and model definitions suitable for source control. Which authoring format fits?
38. An Import model's incremental-refresh filter cannot fold to a large SQL source. What risk should the team investigate?
39. Analysts need to read workspace content but must not publish or change items. Which workspace role is the usual starting point?
40. Customer versions contain BusinessKey, UpdatedAt, and a unique LoadID. You need the latest row per BusinessKey with deterministic tie-breaking. Which design fits?
41. Data is already stored in a supported external object store. Analysts want OneLake access without maintaining a second copy. What should be considered?
42. Finance needs overall margin percentage to remain numeric and respond to filters. Which practices are appropriate? Select 2 answers.
43. Finance wants one revenue measure to display currency and unit measures to remain numeric with different formats. Which feature can alter formatting without converting numeric results to text?
44. In KQL, a dashboard needs five-minute event buckets with counts. Which expression supplies the grouping bucket?
45. Orders contains three rows for CustomerID 7; Customer contains two duplicate rows for that ID. What happens when an inner join matches only CustomerID?
46. Sales has Region and Amount. Which queries return only regions whose total Amount exceeds 100000? Select 2 answers.
47. Two source systems use different customer identifiers. Which preparation step is necessary before reliable consolidated customer analysis?
48. Users may read sales rows but must not discover a sensitive salary column in the semantic model. Which control addresses column and metadata visibility?
49. Which changes can reduce model query cost without changing required results? Select 2 answers.
50. Which practices improve analytics lifecycle safety? Select 2 answers.

Comments — 0