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