Question And Answer
Question: Apps for the Power Platform are available from where?
Question: How can a user create a refreshable data source?
Answer: by storing their file in the cloud
Question: How can a user view their uploaded data immediately in Power BI?
Answer: by clicking “View Dataset”
Question : You;ve loaded a sample dataset that includes reports and dashboards. If you later delete the sample dataset, Power BI will also _____.
Answer: delete the reports and dashboards
Question : What is an additional step a user must take in order to bring in data directly from a file that was not created in Excel, a CSV file, or Power BI desktop?
Answer: Get the data into Excel, a CSV or Power BI desktop model.
Question :Which of these methods can be used to create a new report that can be saved in Power BI?
- A;.Copying and editing an existing report
- B. Downloading a Power BI report from SharePoint and re-uploading
- C. Using fields from a dataset to create visualizations
- D. Creating a visualization in Paint or Paint 3D and uploading to Power BI
Question : The data you selected for visualization includes geospatial data, so Power BI created a map. You wish to present your data in columns and rows. What should you do?
Answer: Select the visualization then click on the Table visualization
Question : What do geospatial visualizations require?
Answer: geospatial data (latitude, longitude)
Question: How can a user change the criteria by which values are sorted within a column (highest value -> lowest vs. lowest value -> highest)?
Answer: Click at the top of the column.
Question : How does a user create a dashboard?
Answer: Take visualizations from reports and pin them as tiles.
Question : Which statement about formatting visualizations is true?
Answer: Different visualizations will have different formatting options available.
Question : You are creating a sales report. The first page includes some visualizations illustrating national sales. Why might you choose to add a second page to this report?
- A. You have more national sales visualizations than fit well on page
- B. You need 10 visualizations, and only 6 are allowed per page
- C. The report will include regional sales visualizations.
- D. Reports are limited to one page.
Question :You have just deleted Page 1 of your report. When is it permanently deleted?
Answer: when you save the report
Question: Which users have the ability to apply a filter to all pages of a report?
Answer: report creator/owner
Question: After you’re finished working with a visualization’s interaction settings, what is best practice?
Answer: Turn off Editing Interactions.
Question : If a print a report from Power BI Service using Export, the print job will include _____.
Answer: the current page
Question: One attribute of Power BI reports is that they are _____.
Answer: printable and exportable by users
Question: How can a dashboard creator make a dashboard easier to view on a mobile phone?
Answer: Create a phone view for the dashboard.
Question: Why would you pin a live report page to a dashboard? (choose more than one)
- A. to force users to access the dashboard through the report
- B.to allow users to cross-filter the visualizations as they would in the report
- C.so the visualizations will automatically update when the report updates
- D.so that filters added to the report are propagated to the dashboard
Question: Which choices are valid ways to create a dashboard?
A.Go to Dashboards and select Create
B.Create a dashboard from existing content
C.Select New Dashboard from a SharePoint list
D. Create a dashboard using visualizations from a report
Question : When can a user create a mobile view?
Answer: after they’ve pinned a tile to the dashboard
Question: When will a user see their default dashboard?
Answer: immediately upon opening Power BI
Question: You use Add a Tile to add content that doesn’t come from Power BI. Using Add a Tile you can add text boxes, streaming content, and what else? (choose more than one)
- A. Images from the web
- B. Images from your computer
- C.Video from YouTube
- D.Web content for which you have a URL
Question: What is an easy way to have Power BI keep a user up to date on the status of critical values in their dashboards?
Answer: Set alerts.
Question : If a user wishes to subscribe another user to a dashboard or report, what do they need?
Answer: editing permissions to that dashboard/report
Question: How can a user keep a visual generated as a result of a Power BI Q& session?
Answer: Pin it to their dashboard.
Question: What is the primary difference between creating a new workspace in Power BI vs a classic workspace?
Answer: A new workspace does not automatically generate an Office 365 group.
Question: What are the four roles available in Power BI workspaces?
Answer: viewers, contributors, members, admins
Question: In order to share within their organization, a user needs at least _____.
Answer: a Power BI Pro license
Question : Which option or options are available as a choice in the app workspace?
Answer: OneDrive Business
Question : What must be included when publishing an app? (choose one or more)
D.Owner’s profile photo
Question : What is generated when you click “Publish”?
Answer: a link that can be sent in email, and an HTML link that can be pasted into a blog or website
Question: Which is true regarding publishing to the web?
Answer: Some items, like Arc GIS visualizations, cannot be published
Question : How can a user find out who has access to a report or dashboard?
Answer: Go to their workspace, click the Share button and choose Access.
Question: What can you NOT do from the Power BI mobile app?
Answer: Remove a tile from a dashboard.
Question: Use _____ to display your Power BI report in presentation mode with live filtering.
Answer: Power BI app for Windows 10
Question : Which workspaces does a user have access to in the Power BI mobile app?
Answer: all workspaces
Question : Power BI Mobile can be downloaded onto _____.
Answer: mobile devices, smartphones, tablets
Question : What does the mobile app’s Quick Access tab display?
Answer: Reports and dashboards
Question :If a user wishes to work with multiple data sources and connect them through relationships, which tool is best suited?
Answer: Power BI Desktop
Question : If a user wishes to create a dashboard, where tool must they use?
A.Power BI Desktop
B.Power BI Service
C.Power BI Mobile
Question: Why might a user wish to start their reports in Power BI Desktop vs Power BI Service?
Answer: Reports started in Power BI Desktop are “portable” and can be worked on in Power BI Service.
Question : What does “Data View” show?
Answer: all of the data in a dataset
Question: Reducing data with the Power Query Editor would not include which of these actions?
Answer: Hide rows with null values.
Question : As a general rule of thumb, data used in Power BI should be what? (choose more than one)
A.Longer rather than wider
B.Wider rather than longer
C.More columns than rows
D.More rows than columns