PL-300: Microsoft Power BI Data Analyst with 100% correct answers

Which data role enables advanced analytics capabilities specifically through reports and visualizations? -Data scientist -Data engineer -Data analyst Data analyst -A data analyst uses appropriate visuals to help business decision makers gain deep and meaningful insights from data. Which data analyst task has a critical performance impact on reporting and data analysis? -Model -Analyze -Visualize Model -An optimized and tuned data model performs better and provides a better data analysis experience. Which one of the following options is the most important key benefit of data analysis? -Decisive analytics -Informed business decisions -Complex reports Informed business decisions -A key benefit of data analysis is the ability to gain valuable insights from a business's data assets to make timely and optimal business decisions. What is the common flow of activity in Power BI? -Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service. -Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop. -Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile. -Bring data into Power BI mobile, create a report, then share it to Power BI Desktop. Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile. -The Power BI service lets you view and interact with reports and dashboards, but doesn't let you shape data. Which of the following are building blocks of Power BI? -Tiles, dashboards, databases, mobile devices. -Visualizations, datasets, reports, dashboards, tiles. -Visual Studio, C#, and JSON files. Visualizations, datasets, reports, dashboards, tiles. -Building blocks for Power BI are visualizations, datasets, reports, dashboards, tiles. A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI? -The canvas. -Scheduled refresh. -An app. An app. -An app is a collection of ready-made visuals, pre-arranged in dashboards and reports. You can get apps that connect to many online services from the AppSource. When connecting to a SQL Server database to get data, what language should you use to extract data? -DAX -T-SQL -MDX T-SQL -T-SQL is the query language that you would use for SQL Server. You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect? -Import -T-SQL -Live connection Live connection - This will reflect cube changes immediately. What can you do to improve performance when you're getting data in Power BI? -Remove unnecessary columns and rows -Export database files to CSV to load -Combine date and time columns into a single column Remove unnecessary columns and rows - Always use the least amount of data needed for your project. 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. That function AVERAGE of data will be incorrect. - AVERAGE takes the total and divides by the number of non-null values. If NULL is synonymous with zero in the data, the average will be different from the accurate average. 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 Append -Append will take two tables and combine it into one query. The combined query will have more rows while keeping the same number of columns. Which of the following selections are not best practices for naming conventions in Power BI? -Rename columns to have spaces in them. -Abbreviate column names. -Replace values that have integers with human readable results. Abbreviate column names. -Abbreviations lead to confusion because they are often overused or not universally agreed on. What does data granularity mean? -Data granularity is the filter direction that is associated with the relationship between two columns. -Data granularity is the level of detail that is represented in the data. -Data granularity is a many-to-many relationship. -Data granularity is a type of schema design. Data granularity is the level of detail that is represented in the data. -Data granularity indicates the level the detail within the data, so the higher the granularity, the more detail that is represented in the data. What is the difference between a fact table and a dimension table? -Fact tables contain observational data while dimension tables contain information about specific entities within the data. -Fact tables contain information about specific entities while dimension tables contain information about observational data. -There is no difference. -Dimension tables tell you about specific roles in Power BI while fact tables tell you information about facts that are associated with those roles in Power BI. Fact tables contain observational data while dimension tables contain information about specific entities within the data. -Fact tables contain observational data such as sales orders, employees, shipping dates, and so on, while dimension tables contain information about specific entities such as product IDs and dates. What is cardinality? -Cardinality is the measure of unique values in a table. -Cardinality is the granularity of the data. -Cardinality is how long it takes for the data to load. -Cardinality is a type of visual element. Cardinality is the measure of unique values in a table. -An example of high cardinality would be a Sales table as it has a high number of unique values. Which two functions will help you compare dates to the previous month? -CALCULATE and PREVIOUSMONTH -TOTALYTD and PREVIOUS MONTH -CALCULATE and TOTALTYD CALCULATE and PREVIOUSMONTH -CALCULATE and PREVIOUSMONTH help you compare dates to the previous month. Why would you want to override the default context? -To create measures that behave according to your intentions, regardless of what the user selects. -To create measures that do not summarize or average. -To create new relationships. To create measures that behave according to your intentions, regardless of what the user selects. -You would want to override the default context to create measures that behave according to your intentions, regardless of what the user selects. How do you use an inactive relationship in a single measure? -Change the active relationship in the Modeling tab. -Use the USERELATIONSHIP function. -Delete one relationship. Use the USERELATIONSHIP function. -This function will change which relationship is used in a single measure. What benefit do you get from analyzing the metadata? -The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset. -The benefit of analyzing the metadata is to get familiar with your data. -The benefit of analyzing the metadata is to know the number of rows, columns and tables being loaded into your model. The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset. -The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset. What can be achieved by removing unnecessary rows and columns? -It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact. -Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model. -Deleting unnecessary rows and columns can damage the structure of the data model. Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model. -Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model. Is it possible to create a relationship between two columns if they are different DATA TYPE columns? -Yes, if cardinality of the relationship is set to Many-to-Many. -No, both columns in a relationship must be sharing the same DATA TYPE. -Yes, the above is fully supported in latest version of Power BI desktop. No, both columns in a relationship must be sharing the same DATA TYPE. -No, it is not possible to create a relationship between two columns if they are different DATA TYPE columns. Both columns in a relationship must be sharing the same DATA TYPE. What is the benefit of using a report tooltip? -To give users additional information about a report visual, such as the author and date/time it was created. -To provide additional detail that is specific to the context of the data that is being hovered over. -To give users the ability to export data from the visual. To provide additional detail that is specific to the context of the data that is being hovered over. -The benefit of using a report tooltip is it provides additional detail that is specific to the context of the data that is being hovered over. Which of the following options isn't one of the four components in the Q&A visualization? -The question box, where users enter their question and are shown suggestions to help them complete their question. -A pre-populated list of suggested questions -Automatic creation of a custom tooltip -An icon that users can select to convert the Q&A visual into a standard visual. -An icon that users can select to open Q&A tooling, which allows designers to configure the underlying natural language engine. Automatic creation of a custom tooltip -Automatic creation of a custom tooltip isn't one of the four components in the Q&A visualization. Do you need to import custom visuals each time you want to use them when you're developing a new report, not an existing report? -No, custom visuals are always available for selection under the Visualization pane. -yes, custom visuals must be imported from AppSource each time you start developing a new report. -No, custom visuals only need to be imported once and will always remain in Power BI for future use in a new report. yes, custom visuals must be imported from AppSource each time you start developing a new report. -Custom visuals must be imported each time you start developing a ne