Power BI exam questions fully solved & updated 2024

Which of the following are covered in the 70-778 exam? (Choose three) Modeling and visualizing data Connecting and transforming data Dashboards, reports, and apps Datasource maintenance and refresh schedules Modeling and visualizing data Connecting and transforming data Dashboards, reports, and apps Upon signing in to the Power BI web service, which of the following do you download? A. Power BI Mobile B. Power BI Desktop C. Data Gateway D. Power BI for Excel Power BI Desktop Which button loads the selected worksheet(s) into RAM? (Random Access Memory) A. Open B. Edit C. Load D. Import Load To provide a custom SQL query in your database connection, you must expand which window? A. Import B. Advanced C. Query D. Custom SQL Advanced Where can you add more users to be allowed to use the data gateway? A. The Administrators tab under Manage Gateways B. The Users tab under Manage Gateways C. The Users tab of the Add Datasource page under your Gateway D. The Dataset settings under each report The Users tab of the Add Datasource page under your Gateway Imported data connections allow for which of the following? (Choose three) Faster performance Up to the second visualization refreshes No limitations to functionality Data compression Faster performance No limitations to functionality Data compression Which of the following is the scripting language of Power Query? A. PowerQL B. SQL C. M D. DAX M The Using Locale feature allows you to adjust how Power Query parses a column based on the standard of a geographical region. True or false? A. True True Remove Duplicates will remove duplicate records across all columns in the data set. True or false? A. True B. False False To split a column on a period (.) delimiter, which of the following should you select? A. Period B. Sentence End C. Custom D. Semicolon Custom Basic arithmetic can be processed by clicking on which dropdown? A. Trigonometric B. Standard C. Statistic D. Arithmetic Standard Unpivot Other Column will unpivot only the selected column. True of false? A. True B. False False To create a new column based on a selected column and selected example, which of the following should you select? A. Conditional Column B. Custom Column C. Column from Example D. Column with Custom Function Column from Example Filtering data in Power Query gives you the same flexibility as building a custom conditional column. True or false? A. True B. False False Parameters show up in which section of PowerQuery? A. Transform tab B. Applied steps C. Queries D. Data preview Queries An inner join will return which data? A. All data from the right sheet and matches from the left B. All data from the left sheet and matches from the right C. Only data that has an exact match in both sheets D. All data Only data that has an exact match in both sheets To convert a column in a query to a standalone list, which of the following should be selected? A. Statistics B. Get Data C. Convert to List D. Add as New Query Add as New Query Which of the following attempts to get data from a column and can handle errors if any arise? A. if then B. raise error C. switch D. try try Clicking on Format > Clean will have which effect on your text columns? A. Lowercases each word B. Capitalizes each new word C. Removes non-printable characters D. Removes unnecessary spacing Removes non-printable characters A solid line in the relationships pane represents which of the following? A. A one-to-many relationship B. A one-to-one relationship C. A two-way relationship D. An active relationship An active relationship You can change the format of a date or number column by clicking on which of the following first? You can change the format of a date or number column by clicking on which of the following first? A. Text Transform B. The column name in the Fields pane C. Format D. Transform The column name in the Fields pane Citing columns in DAX is written in which format? A. 'Table'[Column] B. n C. Table:Column D. Table.Column 'Table'[Column] In DAX, the SUBSTITUTE function is case sensitive. True or false? A. True B. False True To calculate an average measurement row by row, which of the following should be used? A. ROWAVERAGE B. AVG C. AVERAGE D. AVGX AVGX The RELATED function only works if there are relationships already in place in the data model True or false? A. True B. False True In DAX, which of the following is the correct syntax for the IF function? A. IF(Expression, Then, Else) B. IF expression THEN value ELSEIF expression THEN value ELSE value C. VAR RETURN IF expression THEN value ELSEIF expression THEN value ELSE value D. CASE IF expression THEN value ELSEIF expression THEN value ELSE value END IF(Expression, Then, Else) If you want SWITCH to evaluate if an expression is true, where should you place TRUE()? A. The last line B. The first line C. At the beginning of the expression D. At the end of the expression The first line To load variables in to an IF function, which of the following is required? A. LOAD B. BEGIN C. VAR D. RETURN RETURN When you add categories or dimensions to a visualization, why are calculated columns you've created adjusted based on the category? A. Filter level context B. Data level context C. Row level context D. Categorical context Filter level context