اضغط هنا للانضمام الى قروب فوجي للإختبارات على تيليقرام

أرشيف أسئلة الاختبار

اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

هذه الصفحة مخصصة للأرشفة وتعرض جميع أسئلة الاختبار وروابط كل سؤال مع الخيارات والنقاشات.

الأسئلة

50 سؤال
  1. You have a semantic model. You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions. Which three acti ...
  2. You have a semantic model. You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions. Which three acti ...
  3. You have a Fabric workspace that contains the items shown in the following table. Headcount — Report Headcount — Semantic model Company Expenses — Report ...
  4. From Power BI Desktop, you publish a new semantic model and report to a Power BI workspace. The semantic model has a row-level security (RLS) role named HR. ...
  5. You have a Power BI workspace that contains a single-page report named Sales. You need to add all the visuals from Sales to a dashboard. The solution must en ...
  6. You have a Power BI app that contains a report named Report1. You add a new page to Report1. You need to ensure that users can view the new page. The solu ...
  7. You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products. You need to display ...
  8. You have a Fabric workspace named Workspace1 that contains a semantic model named DS1 and a report named RPT1. A user wants to create a report by using the d ...
  9. You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet. Sales_Spreadsheet contains the following columns: C ...
  10. You plan to create a Power BI report that will be connected to multiple data sources. One of the data sources contains tax records. You need to ensure that o ...
  11. You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: Customer ID Customer Name Phone ...
  12. You plan to create a Power BI semantic model to analyze attendance at a school. Data will come from two separate views named View1 and View2 in an Azure SQL dat ...
  13. You are using Microsoft Power BI Desktop to profile data in Power Query Editor. Table data is displayed as shown in the following exhibit. Use the drop-do ...
  14. You use Power Query Editor to review a query that contains a column named Country. You need to view the following information in the Data preview view for th ...
  15. You have a folder that contains 50 JSON files. You need to use Power BI Desktop to make the metadata of the files available as a single semantic model. The s ...
  16. You have a Power BI data model that imports data from a Microsoft Excel spreadsheet. You use Power Query to load a query that contains both renamed and custo ...
  17. You use Power Query Editor to ingest data into Power BI Desktop from two Microsoft SharePoint Online lists named Customers and Locations. Each list contains ...
  18. You have a Microsoft Power BI semantic model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Order ...
  19. You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1: Products: abc de ...
  20. You have a Power BI semantic model named Model1 that contains a single table named Sales. Sales contains the following columns: Customer_Name (Text) Sale ...
  21. You have a semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power BI report that meets th ...
  22. You have data in a Microsoft Excel worksheet as shown in the following table. You need to use Power Query to clean and transform the dataset. The solution mu ...
  23. You have a Power BI semantic model named Model1 that contains two fields named Sales and Quarter. Model1 contains a DAX measure that sums the Sales column. Y ...
  24. You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except fo ...
  25. You have a Power BI report. The report contains a visual that shows gross sales by date. The visual has anomaly detection enabled. No anomalies are detected. ...
  26. You have a Power BI Desktop semantic model that contains a table named Sales. Sales contains the following columns: OrderDate OrderID ProductID SalesAmoun ...
  27. You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows historical employ ...
  28. You have a Power BI report that contains a table visual. The visual contains a column. The column contains whole numbers ranging from 1 to 20. You need to ...
  29. You are configuring a Power BI report for accessibility as shown in the following You need to change the default colors of all three visuals to make the repo ...
  30. In Power BI Desktop, you are creating visualizations in a report based upon a semantic model that contains imported data. You need to allow Power BI users to ...
  31. You have a Power BI report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What shoul ...
  32. You have a Power BI report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar ...
  33. You have a Power BI semantic model named Model1 that runs in Import storage mode. You need to reduce the size of Model1. Which two actions should you perf ...
  34. You use Power Query Editor to preview the data shown in the following exhibit: You confirm that the data will always start on row 3, and row 3 will always cont ...
  35. You are creating a semantic model that contains a table named Store. Store contains the following fields: You plan to create a map visual that will show store ...
  36. Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must ...
  37. You are creating a quick measure as shown in the following exhibit: Calculation: Rolling average Period: Days Periods before: 1 Periods after: 0 Availa ...
  38. You have a semantic model that contains a table named Employees. The table contains the following columns: Employee ID First Name Last Name Department Sa ...
  39. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the ...
  40. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the ...
  41. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the ...
  42. You have a semantic model that contains the following data: The Date table relates to the Sales table by using the Date columns. The model contains the fo ...
  43. You have a Power BI model that contains several tables. Each table contains multiple columns. You discover that some columns are redundant and are NOT requir ...
  44. You have a Power BI semantic model named Model1 that runs in Import storage mode. You need to reduce the size of Model1. The solution must NOT increase repor ...
  45. You are profiling data by using Power Query Editor. You have a table that contains a column named column1. Column statistics and Value distribution for colum ...
  46. You have a semantic model that contains a single table named Pens. Pens contains the following columns: Item Unit Price Quantity Ordered You need to ...
  47. The semantic model takes a long time to refresh. You need to modify Posts and Traffic queries to reduce load times. Which two actions will reduce the load ...
  48. You have a semantic model as shown in the following exhibit: You need to use the drop-down menus to select the answer choice that completes each statement ba ...
  49. You are creating a quick measure as shown in the following exhibit: You need to create a monthly rolling average measure for Sales over time. How should y ...
  50. You have a Power Bl report named Orders that supports the following analysis: • Total sales over time • The count of orders over time • New and repeat custom ...