Learning Power BI Desktop EXAM questions already graded A+

Which statement is true regarding the Power BI Desktop sign-in step? Microsoft offers a trial period to use Power BI Pro features. Which view is not offered when you launch Power BI Desktop for the first time? Connections What is Power BI? a self-service business intelligence solution Which capability is missing from the Power BI service? robust data modeling using the drag-and-drop feature When connecting Power BI Desktop to a web data source pointing to a webpage with multiple tables, what can you preview? You can preview all tables individually. You can preview all tables individually. connecting to data models created in legacy tools, such as Power Pivot and Power Query Does Power BI Desktop truncate the preview for an Access database connection? Yes it does, by the data size. Which statement is false regarding the Navigator window that opens when you connect to an Excel file? It allows you to delete data rows. How is previewing a CSV file before loading it different than previewing an Excel file? How is previewing a CSV file before loading it different than previewing an Excel file? What does the Transpose action perform? Switch the rows and columns with each other. Which statement is false regarding the Applied Steps in Power Query Editor? Adding a step immediately changes the underlying data source. When will the Replace Values operation generate an error? when replacing numeric values with letters Your company is tracking sales data in Excel. What would be your recommendation on how to arrange this data for a multiyear analysis? Keep all the data in one big sheet, with columns to denote the sale date and year. Which statement is false regarding a column index that you add using the default choices? It starts with index 1. When merging tables in Power BI Desktop, which join kind shows all rows from the second table, and matching from the first table? right outer Which language is behind the custom query formulas? M What step should you perform before adding data from more tables, if you need to eventually aggregate the data by which table it originally came from? Add a custom column to each table, set to the table name. What should you check before changing a text column to a decimal number type? Negative values use the minus symbol, not a hyphen. Which cardinality will you use to represent a bank customer in one table related to different bank accounts in a different table? one to many What does the index of a row represent when you add an index column? the position of that row in the row order What is a quick way to tell that data that consists of numbers is actually formatted as text? The values will be left-justified. When merging two tables using a left outer join, what shows when there is no match? Cells that do not match will show null. You need to add another column to your data that simply sets all values to the text "complete". Which custom column formula should you use? ="complete" Which statement is false regarding custom visuals? They have to be purchased. In a standard card visualization, a field added to the card is added at the _____. right Your report consists of a bar chart and a tree map visualizing the same data. What happens when you select one bar in the bar chart? The selection is highlighted in both visualizations. How can adding a card visualization to your map help? The card can show more details on data selected in the map. Preset styles _____. are based on the theme Which statement is not true regarding the Q&A visualization? By default, field names entered in the Q&A visualization must match the field names in the data model. What is not an option with Q&A Setup? Format Q&A visualization Which statement is true regarding slicers? A slicer can filter at both the page level and the report level. A slicer can filter at both the page level and the report level. data reporting Which defaults will a report have for its filters when it is imported into the Power BI service? The filters will default to the same values they were last saved with. The filters will default to the same values they were last saved with. Yes, quick insights are offered, even if you just publish a data set. What happens when you publish a PBIX file with a name that is already used? The system will ask whether you want to replace the data set.