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

PRO-PL300

الاختبار النهائي — محلل بيانات Power BI رمز PL-300 (تحضير الامتحان)

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

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

ادرس الدورة ←

السؤال 1A company stores 2 TB of sales transactions in an Azure SQL Database that updates continuously. Business users need near real-time figures and the dataset must not exceed Power BI's per-dataset memory limits. Which storage mode should the analyst use for the fact table?
السؤال 2An analyst combines a large DirectQuery fact table with a small Import dimension table in one model. Which storage mode should be set on the dimension table so it can support relationships with both Import and DirectQuery tables efficiently?
السؤال 3Sales[Amount] contains values such as 100 and 250. The analyst needs a measure that returns the running total of sales ordered by date. Which DAX pattern is correct?
السؤال 4An analyst needs a measure showing total sales for the same period last year. The model has a marked Date table. Which DAX expression should be used?
السؤال 5An analyst wants a column on the Sales table that classifies each row as 'High' when Sales[Amount] exceeds 1000 and 'Low' otherwise, evaluated once per row at refresh time. What should be created?
السؤال 6A measure [Profit Margin] = DIVIDE([Profit], [Sales]) returns blank for products with no sales, but the analyst wants 0 displayed instead. What is the correct change?
السؤال 7An analyst needs the count of distinct customers who placed an order. Which DAX measure returns this correctly?
السؤال 8A report must apply row-level security so each regional manager sees only their region's data, where the manager's email matches a column in a Security table. Which DAX filter on the Security table achieves dynamic RLS?
السؤال 9After defining a role with a table filter in Power BI Desktop, the analyst publishes to the service. Which additional step is required for users to actually be restricted by that role?
السؤال 10A user is a member of an RLS role AND is also granted Admin on the workspace containing the dataset. Why might that user still see all rows regardless of the RLS filter?
السؤال 11An analyst wants to share a read-only report with 200 external recipients who do not have Power BI Pro licenses, while keeping the report private (not on the public web). What is the recommended approach?
السؤال 12On a report page, an analyst wants a button that, when clicked, returns all visuals and slicers to a specific predefined state. Which feature should be used?
السؤال 13When creating a bookmark intended only to toggle the visibility of a set of visuals (a show/hide menu) without forcing the current filter selections onto users, which bookmark option should be unchecked?
السؤال 14An analyst must make a report accessible to keyboard and screen-reader users. Which action most directly improves screen-reader support for the visuals?
السؤال 15A stakeholder reports that color alone is used to distinguish series, which is hard for color-blind users. Besides choosing a color-blind-friendly theme, which formatting option best conveys the distinction?
السؤال 16An analyst wants a single slicer on the Summary page to also control visuals on the Detail page. Which feature enables this without duplicating the slicer's selection manually?
السؤال 17By default, clicking a column in a bar chart cross-filters another visual on the page. An analyst wants the click to cross-highlight instead, or to have no effect on a specific card. Where is this configured?
السؤال 18A dataset uses DirectQuery against a data warehouse. The analyst notices time-intelligence functions like TOTALYTD behave unexpectedly. What is a key consideration when using time intelligence in DirectQuery models?
السؤال 19An analyst wants the report's sensitive financial dataset to carry a classification label that travels with exported files (Excel, PDF) and enforces encryption. Which governance feature should be applied?
السؤال 20In Power Query, a sales table has a 'Region' column containing the values 'North', 'NORTH', and ' north ' that should all be treated as the same region. Which sequence of transformations most reliably consolidates these values before grouping?
السؤال 21You import a CSV where the first three rows contain report metadata and the actual column headers are on row 4. In Power Query, what is the correct approach to get clean headers?
السؤال 22A monthly sales report arrives as 12 columns named Jan, Feb, ... Dec, with one row per product. You need a tidy table with columns Product, Month, and Sales for analysis. Which Power Query transformation achieves this?
السؤال 23You are combining 50 identically structured CSV files from a folder. After using 'Combine Files', the query is slow to refresh and you want maintainable logic. What is the recommended pattern Power Query generates and you should preserve?
السؤال 24While shaping a large SQL source in Power Query, you want to ensure transformations are pushed back to the database engine for performance. Which concept describes this and how do you verify it?
السؤال 25You add a custom column in Power Query that calls a web service per row, which breaks query folding and slows refresh. The same lookup could be done after load. Which redesign best preserves folding for the rest of the query?
السؤال 26A column 'OrderDate' loads as Text like '2024-03-15'. Some rows are blank and some contain 'N/A'. You set the type to Date and the query throws errors. What is the most robust handling in Power Query?
السؤال 27You merge a fact 'Sales' query with a 'Products' query in Power Query using a left outer join on ProductID. After expanding, several rows show null for product attributes. What does this indicate?
السؤال 28A model imports a wide 30-million-row table, but reports only ever use 6 of its 40 columns. The PBIX is large and refresh is slow. Which optimization gives the biggest VertiPaq size and performance gain?
السؤال 29Two high-cardinality columns drive most of your model size: a 'TransactionID' surrogate column never used in any visual or relationship, and a 'DateTime' column with seconds precision. Which pair of actions best reduces model size?
السؤال 30Performance Analyzer shows a single matrix visual taking 4,500 ms, almost entirely in 'DAX query' time, while other visuals are fast. What is the most appropriate next step?
السؤال 31You want a numeric column to display nicely in slicers and to compress better, but the underlying values are codes like 1001-1500 with no math performed on them. Which change is most appropriate for both usability and model efficiency considerations?
السؤال 32A business user wants to type questions like 'total sales by region last year' and get instant visuals without building them manually. Which Power BI feature should you enable and configure with synonyms?
السؤال 33Management asks which factors most increase the likelihood that a customer churns, and wants to compare segments automatically. Which AI visual is purpose-built for this analysis?
السؤال 34An analyst wants to interactively drill into 'Total Revenue' and let Power BI automatically choose, at each level, the dimension that contributes the highest value. Which visual and feature combination is correct?
السؤال 35On a line chart of monthly sales, you want to project the next 6 months with a confidence band, and you also notice an unusual spike you want explained. Which two analytics features address these needs respectively?
السؤال 36The Forecast feature on a line chart is greyed out and cannot be added. What is the most likely cause?
السؤال 37You use 'Group By' in Power Query to aggregate orders to a daily total, but you also need to keep the underlying rows available for a separate detail page. What is the cleanest design?
السؤال 38You import a Sales fact table and a Product dimension table. Each product appears once in the Product table but many times in Sales. Which relationship cardinality should Power BI create between Product and Sales?
السؤال 39In a star schema with one Sales fact table and Date, Product, and Customer dimensions, what is the recommended cross-filter direction for the relationships between the dimensions and the fact table?
السؤال 40A model has two relationships between the Sales table and the Date table: one on OrderDate (active) and one on ShipDate (inactive). You need a measure that totals sales by ShipDate. Which DAX function activates the inactive relationship for that measure?
السؤال 41Two dimension tables (Product and Store) both have a one-to-many relationship to the Sales fact table, and there is no direct relationship between Product and Store. What kind of schema does this represent?
السؤال 42You need to relate a Sales table and a Budget table that share only Month and Region but have no common single-column key, and both contain duplicate combinations. What is the recommended modeling approach?
السؤال 43Which visual is most appropriate for showing the contribution of each product category to total sales as parts of a whole at a single point in time, when there are only four categories?
السؤال 44You want a report page where users can drill from a country-level column chart down to individual cities by clicking a data point. Which feature should you enable on the visual?
السؤال 45A stakeholder wants to right-click a sales summary and jump to a detailed page that is automatically filtered to the selected customer. Which Power BI capability provides this?
السؤال 46You created several bookmarks to capture different filter and visibility states and want to build a navigation experience where buttons switch between these states. What should the buttons be set to do?
السؤال 47To improve accessibility, which practice should you apply when designing a Power BI report for users who rely on screen readers?
السؤال 48On a report page you have a Year slicer and a bar chart. You want clicking a bar to highlight related data in other visuals but NOT filter them out completely. Which interaction setting should you choose?
السؤال 49You publish a report to a Power BI workspace and need a colleague to be able to edit the report and its dataset but not manage workspace access or delete the workspace. Which workspace role should you assign?
السؤال 50An imported dataset connects to an on-premises SQL Server database and must be refreshed on a schedule in the Power BI service. Which component is required to enable the scheduled refresh?
السؤال 51Your organization uses Power BI deployment pipelines with Development, Test, and Production stages. What is the primary purpose of these pipelines?
السؤال 52You want several reports to share a single certified dataset rather than each report importing its own copy of the data. Which connection approach should report authors use?
السؤال 53A regional manager should only see sales rows for their own region when they open a shared report. Which Power BI feature enforces this data restriction?
السؤال 54After defining and validating RLS roles in Power BI Desktop and publishing the report, what additional step is required so that specific users are subject to a role in the Power BI service?
السؤال 55You want to distribute a collection of dashboards and reports to a large group of read-only business users with a curated, branded landing experience, without granting workspace access. Which Power BI feature is most appropriate?