PL - 300 Microsoft Power BI Data Analyst Practice Questions with Complete Solutions

PL - 300 Microsoft Power BI Data Analyst Practice Questions with Complete SolutionsPL - 300 Microsoft Power BI Data Analyst Practice Questions with Complete SolutionsPL - 300 Microsoft Power BI Data Analyst Practice Questions with Complete Solutions You plan to get data for a Power BI dataset from flat files. You need to select a location for the files. The location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365 credentials. Which two location types should you recommend? Each correct answer presents a complete solution. Select all answers that apply. a. local file b. OneDrive for Business c. Personal OneDrive account d. SharePoint - Team Sites - ANSWER-b. OneDrive for Business d. SharePoint - Team Sites You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using DirectQuery instead of Import? Each correct answer presents a complete solution. Select all answers that apply. a. full support for the Q&A Power BI service b. full support for the Quick Insights Power BI service c. minimized local disk space usage d. minimized need for data refresh - ANSWER-c. minimized local disk space usage d. minimized need for data refresh You have designed a star schema to simplify your data. You need to understand the relationship between the tables in the star schema. What is the relationship between the fact table and dimension tables? Select only one answer. a. many-to-many b. many-to-one c. one-to-many d. one-to-one - ANSWER-b. many-to-one You create a Power BI Desktop dataset by importing and transforming a data source based on multiple tables in a SQL Server database.