Power BI Certification () | Questions & Answers (100% Correct)

Power BI Certification () | Questions & Answers (100% Correct) Power BI Certification () | Questions & Answers (100% Correct) What lets you connect data to other business applications? - ANSWER - Microsoft Dataverse What lets users connect to pre-wired connections? - ANSWER - PBIDS files What contains sites, document libraries, and folders? - ANSWER - Sharepoint Online What must be used to publish SSAS Tabular live connection data to Power BI Service? - ANSWER - Data Gateway What sources can Power BI connect to? - ANSWER - SQL Database Google Analytics R Scripts What is Query Editor used for? - ANSWER - Shape & transform data before loading into Power BI In which storage mode are tables solely stored in-memory and queries fulfilled by cached data? - ANSWER - Import When to use DirectQuery? - ANSWER - Dataset is too large to be stored in-memory When do you need to access Data Source Settings? - ANSWER - If file name or location changes How can you use parameters when connecting to data? - ANSWER - To change data source values dynamically Which data profiling tools does Power Query have? - ANSWER - Column quality, distribution, and profile Which data profiling tool checks number of errors in a column? - ANSWER - Column Quality Column Profile What can column distribution be used for? - ANSWER - To Identify Primary Keys What is purpose of data profiling in Power Query? - ANSWER - Provide visual way to explore data Get sense of dataset composition Solve column quality issues What tool provides detailed column statistics and value distribution for selected column? - ANSWER - Column Profile When would you use a tool from "Transform" tab over "Add Column" tab? - ANSWER - When you want to overwrite values of existing column When would you use a tool from "Add Column" tab over "Transform" tab? - ANSWER - When you want to keep values of existing columns When you want to create new columns What can be useful to create unique ID's and form relationships between tables? - ANSWER - Adding an index column Which Power Query tool can you use when you know the outcome but don't know which transformations to use? - ANSWER - Column from examples Which PowerQuery tool can you use to roll-up daily transaction data into monthly transactions? - ANSWER - Group By What is true about merging queries? - ANSWER - Allows you to join tables based on common column Adds columns to existing table You can merge queries by different join kinds (left, outer, inner, etc.) How to add rows to existing table? - ANSWER - Append queries What two blocks make up M code that runs query? - ANSWER - let & in What is a risk of having null values in a numeric column? That function SUM of data will be incorrect. That function MAX of data will be incorrect. That function AVERAGE of data will be incorrect. - ANSWER - That function AVERAGE of data will be incorrect. If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform? Append Merge Combine Column - ANSWER - Append