Power BI Certification Practice Exam

These questions are part of the practice quiz. Start practicing

• To enforce data security in a Power BI report, what feature can be utilized?
• What happens to data when you use the "Choose Columns" feature?
• Which feature is utilized to create alternative names for fields in tables to facilitate user interaction with dashboards?
• What is NOT displayed in the navigator window when connecting to an Access database?
• In Live Connection, where are all transformations applied?
• When using the concatenate function in Power BI, what is the expected output type?
• Which of the following statements describes a calculated column?
• What is one method of hiding a field from Report View in Power BI Desktop?
• What does the 'Applied Steps' area in the Query Editor window record?
• What is the role of DAX in Power BI?
• What is the purpose of creating relationships in Power BI?
• How would you visualize sales performance over time in Power BI?
• What types of transformations can be applied to data using Live Connection?
• What is a quick measure in Power BI?
• What is essential for creating a responsive Power BI report?
• Which DAX function can be used to count the number of distinct values in a column?
• What is the purpose of the "Go to Column" feature in Power BI?
• What is a Power BI workspace?
• What is a primary advantage of Power BI dashboards over reports?
• Which DAX formula correctly calculates the previous month number?
• What is the primary function of a gateway in Power BI?
• What is the role of measures in Power BI?
• What should be done to ensure that the data model is designed for optimal visualization performance?
• What does the "Get Data" feature in Power BI allow users to do?
• What is the file size limit to publish a .PBIX file to Power BI Service for free?
• Which of the following is a feature of Power BI Service?
• How does a live connection impact data transformations in Power BI?
• Which three fields are available when creating a Pie chart visualization?
• What is a key benefit of using the Folder connector for multiple files?
• Which DAX expression formats the number to display 20.00%?
• What is the function of the new Selection Pane in Power BI Desktop?
• What are three reasons for which you might use calculated tables?
• How does the "Summarize" function in DAX operate?
• What does Row-Level Security (RLS) in Power BI help to control?
• What effect do slicers have on other visuals in Power BI reports?
• What is the purpose of the TRIM function?
• What is the significance of "Publish to Web" feature in Power BI?
• In Power BI, what type of chart is best suited for showing trends over time?
• How can you make sure that each category manager can see sales of their category only and the CEO to see all sales in the same report?
• Which component allows you to filter, highlight, and view data set tables and fields?
• In Power BI, which function can be used to calculate the distinct count of values in a column?
• What feature allows users to share insights and collaborate in Power BI?
• What is the difference between measures and calculated columns?
• What is a decomposed tree visual in Power BI?
• How can you share Power BI reports with others?
• Which two field options are available when creating a waterfall chart?
• Which components allow for drill-down functionality in a column chart displaying Quantity by Color?
• What page view types are available in Power BI Report View?
• What is the significance of the Power BI community?
• Which platform does not support R visuals in Power BI?
• What does a star schema do in a data model?
• What type of visual is most suitable for highlighting key metrics in Power BI?
• What is the primary language used to perform complex calculations in Power BI?
• In Power BI, what data format is primarily used for creating reports?
• Months are sorted alphabetically in a Stacked Bar Chart. What can you do to sort it by month number?
• What can you do with individual visuals from a report in Power BI?
• What information is recorded when creating a bookmark in Power BI?
• How can a relationship be created between two tables in Power BI?
• Which DAX formula should you use to estimate the variance of the SalesAmount_USD column for the entire population?
• Which three views are available in Power BI Desktop?
• In Power BI, what type of visual would you use to display two variables and their correlation over time?
• Are columns from an Access database shown in the Navigator window when connected?
• When designing a Power BI project in DirectQuery mode, which statement is correct?
• Which visualization is ideal for helping users understand and analyze cash flow over a financial year?
• In Power BI, which of the following is used to filter data visually?
• When would a tooltip be beneficial in a Power BI report?
• Which Power BI feature helps in visualizing performance against KPIs?
• Why is setting up proper relationships important in Power BI?
• What is the main advantage of using DAX in Power BI?
• Can relationships be defined while using a live connection in Power BI?
• What is the purpose of the "Edit Queries" function in Power BI?
• What is the main benefit of using measures in Power BI?
• When setting up Power BI, which data source do you use if accessing an SQL Server directly?
• The "Remove Errors" option in Power BI is designed to do what?
• Which method can be used to create a query based on the output of another query?
• What should be the data connectivity mode for a historical report that is produced monthly?
• Which of the following is true about Power BI's Page Level Filters?
• Which feature allows users to view detailed data by clicking on a report element in Power BI?
• What is the function of query parameters in Power BI?
• Which visual types are most effective for displaying time-based trends in Power BI?
• To ensure every row in the "Customers" table has a unique ID, what is the best approach?
• What advantage does installing Power BI Desktop from the Microsoft Store offer concerning administrative privileges?
• In which platform can customer visuals be imported?
• What is the purpose of using slicers in Power BI reports?
• If you want your data to automatically refresh as you interact with visualizations in Power BI, which option should you select?
• What benefit does using query parameters provide in Power BI?
• What is the file format used to define a theme for a Power BI report?
• Are you allowed to retrieve data from an existing dataset using the Power BI Service API?
• Which of the following is a benefit of using bookmarks in Power BI reports?
• What does DAX stand for in Power BI?
• What does the option "Assume Referential Integrity" accomplish when creating relationships in Power BI?
• Why might organizations prefer the Microsoft Store version of Power BI Desktop?
• Which technology does NOT require an on-premise gateway for data refresh in Power BI?
• Which transformations can you perform by right-clicking a column header in the Query Editor?
• In Power BI Desktop Report view, which three options will create a measure in the Sales table?
• Which of the following is a scenario where personal or on-premise gateway is required for refreshing datasets?
• What DAX function is used to filter a table based on specific criteria?
• In the context of Power BI, what does the term 'drill-through' refer to?
• What result can you expect from using the "Split Column by Delimiter" transformation at each occurrence of the delimiter?
• What is true about using variables in DAX?
• What does the "Data view" in Power BI allow you to do?
• What is the most efficient way to connect to Excel files for automatic updates?
• What distinguishes a report page tooltip from a regular tooltip in Power BI?
• When should alerts be used in Power BI?
• How can you create a hierarchical slicer in Power BI?
• Into which scope can you import a custom visual created for Power BI?
• When connecting to an Access database, what entities are displayed in the navigator window?
• Does a live connection store data within Power BI?
• What is a unique characteristic of a referenced query in Power BI Desktop?
• What do you need to append to the URL of a Power BI Dashboard to collapse the navigation pane by default?
• Which model approach is preferred when importing data from an OLTP database into Power BI?
• How does a Power BI report differ from a dashboard?
• How can you perform a data refresh in Power BI?
• What does the term "data model" refer to in Power BI?
• What type of visualization should you use to compare the contributions to a total across multiple categories?
• Which method is NOT suitable for performing data refresh in Power BI?
• Which operation allows you to efficiently combine rows from multiple sources into one table?
• How can you schedule a refresh for a dataset in Power BI?
• In Power BI, what is the primary purpose of usage metrics reports?
• Which command is used in Power BI Desktop query editor to create a query that sources from another query?
• How can you ensure data accuracy in Power BI reports?
• In which scenario would an on-premises gateway be necessary for refreshing a dataset in Power BI Service?
• In Power BI, what is the first step to create a report from a dataset?
• What does a KPI visual in Power BI primarily display?
• What is the primary purpose of creating a calculated table in Power BI?
• Is it possible to import data from a SQL Server Analysis Service database directly into Power BI?
• Which of the following can be considered a limitation when using Live Connection?
• By default, which filter level behaves the same as a slicer in a report in Power BI Desktop?
• What does the Power BI feature "Data-Driven Alerts" allow users to do?
• Which type of visualization is typically used to represent geographic data in Power BI?
• What is the primary purpose of the 'Source' step settings in Query Editor?
• When appending data in Power BI, what is essential to maintain?
• What does the "Choose Columns" feature do in Power BI?
• Which of the following is NOT a requirement for refreshing datasets from Azure SQL Database and SharePoint Online?
• What is the process of publishing a Power BI report?
• What does the "Hide in Report View" option do in Power BI Desktop?
• Which components are part of the Power BI ecosystem?
• When using DirectQuery, which feature is not available?
• If the relationship for the Invoice Date Key from the Sale table is inactive, how should you create a line chart for Quantity by the invoice date?
• Which datasets are supported for live connections in Power BI?
• What are measures in Power BI created with DAX primarily used for?
• What does a drill-through page in Power BI primarily allow?
• How can a user ensure their Power BI reports are interactive?
• Explain the use of the "What If" parameter in Power BI.
• Which type of dataset in Power BI always stores its data in Azure SQL Database?
• What are custom visuals in Power BI?
• Which of the following visuals is not included as part of Power BI and must be added as a custom visual?
• How do you prevent drill-down functionality on a specific visual in Power BI?
• What is the primary benefit of using INNER JOIN instead of OUTER JOIN in Power BI?
• What type of sources can Power BI connect to?
• Which of the following options allows for a better management of user access in Power BI?
• What is a key feature of DAX used for analysis in Power BI?
• To use the PowerBI web part in SharePoint Online, what licensing is required for both the report author and all report consumers?
• What is the function of hierarchies in Power BI?
• What type of data transformation would you use when merging two tables with different column structures?
• What is a key advantage of installing Power BI Desktop from the Microsoft Store?
• What does configuring dashboard alerts require in terms of visual support?
• Why is the "Go to Column" feature helpful in Power BI?
• What is the primary function of Power Query in Power BI?
• Which of the following features do Power BI reports offer that dashboards do not?
• Which of the following is a valid reason for using alerts in Power BI dashboards?
• Which view shows the graphical representation of data tables structure in Query Editor?
• Which Power BI feature helps to communicate insights through visual representations?
• What is a primary feature of the Report view in Power BI Desktop?
• In Power BI, what does a .PBIX file represent?
• What happens to the data types of Query Editor that are not available in the data model while loading data?
• For a Power BI report showing real-time sales data, which data connectivity mode is most appropriate?
• Which of the following statements regarding measures in Power BI is correct?
• What is the use of the "Select Related Table" option while importing data from SQL Server?
• How do you apply conditional formatting to visuals in Power BI?
• What is the significance of "data lineage" in Power BI?
• Which method can be used to track user activities in Power BI?
• What does Power BI primarily focus on?
• What role does the "Assume Referential Integrity" option play in data relationships?
• What distinguishes a calculated column from a measure in Power BI?
• Why is it important to manage hierarchies in Power BI?
• What is the primary purpose of a dashboard in Power BI?
• What is a limitation of using a live connection in Power BI?
• Which feature of the Microsoft Store installation of Power BI Desktop allows for convenient updates?
• Which visualization types support configuring dashboard alerts in Power BI?
• Which operations can be accomplished using the Power BI Service API?
• What is the use of filter contexts in Power BI measures?
• What is one of the visualization types you can create in Power BI?
• Is it true that you can create only one bookmark per page in a Power BI report?
• Which of the following data sources can Power BI connect to?
• Which properties of a tile can be edited in Power BI from the Tile details window?
• Where can alerts be set in Power BI?
• Which tool allows the integration of on-premises data in Power BI?
• Which type of alert can be set on a Power BI Dashboard?
• What feature allows users to view data from multiple dimensions in Power BI?
• Can you import data from Power BI Service using Get Data with Power BI dataset option?
• What is the role of bookmarks in Power BI reports?
• Which statement is true regarding the Slicer visual in a Power BI report?
• What types of cross filter directions are available in Power BI table relationships?
• What type of application is Power BI Desktop?
• Which feature in Power BI allows users to see additional data when interacting with visualizations?
• If you want to aggregate sales data, which measure would you create using DAX?
• Which feature allows you to extract data from a website by navigating through HTML tags?
• How do you export data from a Power BI visual?
• What is the main difference between Power BI Desktop and Power BI Service?
• What is a "dataflow" in Power BI?