Result for: Abdul
Exam Name: Power Bi Basic Questions
Download Result (PDF)Email: [email protected]
Total Marks: 50.0
Score: 25.0
Percentage: 50.00%
Question Answers
| Sr. No. | Question | Selected Answer | Correct Answer |
|---|---|---|---|
| 1 | Power BI is primarily used for: | c) Web Development | b) Data Visualization and Business Intelligence |
| 2 | Power BI Desktop is: | a) A cloud service | b) A Windows application for creating reports |
| 3 | Which file extension does Power BI Desktop use to save reports? | b) .pbix | b) .pbix |
| 4 | Power BI Service is also known as: | d) Power BI Desktop | a) Power BI Online |
| 5 | Which of these is not a component of Power BI? | d) Power BI Developer Studio | d) Power BI Developer Studio |
| 6 | Which company developed Power BI? | b) Microsoft | b) Microsoft |
| 7 | What is a Dashboard in Power BI? | b) Collection of visualizations from one or more reports | b) Collection of visualizations from one or more reports |
| 8 | Which view in Power BI Desktop shows tables and fields? | Model View | Data View |
| 9 | The “Get Data” option in Power BI Desktop is used for: | Importing data sources | Importing data sources |
| 10 | Power Query is used for: | Data Modeling | Data Cleaning and Transformation |
| 11 | In Power Query, "M" stands for: | Model | Mashup Language |
| 12 | Which option is used to merge two queries in Power BI? | Group Queries | Merge Queries |
| 13 | To remove duplicates in Power Query, you use: | Remove Duplicates | Remove Duplicates |
| 14 | Which step is applied first in Power Query? | Random step | First step in Applied Steps pane |
| 15 | Can Power Query load data directly into Power BI models? | No | Yes |
| 16 | Which button refreshes data in Power BI? | Refresh | Refresh |
| 17 | In Power Query, splitting a column is done using: | Split Column option | Split Column option |
| 18 | Power Query Editor cannot: | Load data | Create calculated measures |
| 19 | The formula language used in Power Query is | R | M |
| 20 | DAX stands for: | Data Analysis Expressions | Data Analysis Expressions |
| 21 | In Power BI, relationships are created between: | Visuals | Tables |
| 22 | Which is a DAX function? | CONCATENATE | CALCULATE |
| 23 | A measure in Power BI is: | A calculation on aggregated data | A calculation on aggregated data |
| 24 | Calculated Columns are stored in: | Power BI Model | Power BI Model |
| 25 | Which type of relationship is default in Power BI? | None | One-to-Many |
| 26 | Which of these is a time intelligence function in DAX? | TODAY() | TODAY() |
| 27 | To create a hierarchy, you: | Drag fields into each other | Drag fields into each other |
| 28 | Which is true about Measures? | All of the above | All of the above |
| 29 | Which is the default visualization in Power BI? | Card | Table |
| 30 | Tooltips in Power BI are used for | Showing additional details | Showing additional details |
| 31 | Which visualization is best for time series data? | Line Chart | Line Chart |
| 32 | A slicer is used for: | Filtering visuals interactively | Filtering visuals interactively |
| 33 | Conditional Formatting can be applied to: | Model | Tables |
| 34 | Drill through in Power BI allows: | Connecting databases | Navigating to detail pages |
| 35 | A KPI visual is used for: | Showing progress toward a goal | Showing progress toward a goal |
| 36 | In Power BI, bookmarks are used for: | Saving queries | Saving visual states |
| 37 | Which is not a standard Power BI visual? | Matrix | Histogram |
| 38 | Power BI dashboards are created in: | Power BI Desktop | Power BI Service |
| 39 | Which feature updates data automatically in Power BI Service? | Bookmarks | Data Refresh |
| 40 | Row-Level Security (RLS) is used for: | Hiding visuals | Restricting data access for users |
| 41 | Power BI Pro is required for: | Sharing dashboards with others | Sharing dashboards with others |
| 42 | Power BI Mobile app is available on | All of the above | All of the above |
| 43 | Q&A in Power BI allows: | Importing data | Asking natural language questions |
| 44 | Workspace roles in Power BI Service include: | Viewer, Contributor, Member, Admin | Viewer, Contributor, Member, Admin |
| 45 | Which is a limitation of Power BI Free version | Cannot share reports | Cannot share reports |
| 46 | Power BI Premium provides | Free Pro license | Dedicated cloud resources |
| 47 | Which export format is supported in Power BI? | .exe | |
| 48 | Which chart is best to show part-to-whole relationship? | Pie chart | Pie chart |
| 49 | What is the purpose of What-If Analysis in Power BI? | To create hypothetical scenarios using parameters | To create hypothetical scenarios using parameters |
| 50 | What component is created when you perform a What-If Analysis in Power BI? | A parameter table | A parameter table |
Page 1