Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
PL-300 Practice
| Question | Answer |
|---|---|
| You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select? | Dataverse |
| Which storage mode should you select? Customer data that should be refreshed daily | Dual |
| Which storage mode should you select? Date table that should be refreshed every 3 years | Dual |
| Which storage mode should you select? Sales data that should be refreshed near to real time | Direct Query |
| Which storage mode should you select? Sales aggregate data that should be refreshed once per week | Import |
| You publish a PBI report that imports data from an Excel file in a SharePoint folder. The data model contains measures. You need to create a PBI report from the existing data. Which type of data source should you use? | Power BI Dataset |
| STDEV.P(<columnname>) | Returns the standard deviation of the entire population. |
| MEDIAN(<column>) | Returns the median of numbers in a column. |
| RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]]) | Returns the ranking of a number in a list of numbers for each row in the table argument. |
| NORM.DIST(x, mean, standard_dev, cumulative) | Returns normal distribution. |
| T.DIST(x, deg_freedom, cumulative) | Returns student’s left tail t-distribution. |
| Table parameter in DAX | Any DAX expression that returns a table of data for which the expression is evaluated |
| VAR.S(<columnname>) | Provides the variance of a sample population. |
| AVERAGE(<column>) | Provides the average (arithmetic mean) of all values in a column. |
| Order parameter in DAX | A value specifying how to rank values, ascending, or descending. Also an optional parameter. |
| MEDIANX(<table>, <expression>) | Returns the median of an expression evaluated for each row of the table. |
| COUNT(<column>) | This function counts the number of rows in the specified column that contains non-blank values. |
| COUNTBLANK(<column>) | Used to count the number of blank cells in a column. |
| COUNTROWS([<table>]) | This function counts the number of rows in a specified table or a table returned by an expression. |
| DISTINCTCOUNT(<column>): | Provides the distinct values from a column. |
| MAX(<Column>) | Provides the largest number in a column or between two scalar expressions. |
| MIN(<column>) | Return the smallest value from a column or between two scalar expressions. |
| SUM(<column>) | Sum up all values from a column. |
| When a connector in Microsoft Power BI does not support DirectQuery mode, which of the following statements is true? | The connector will default to Import mode. |
| At the beginning of the data analysis process, which of the following activities are important to ensuring a successful analysis outcome? | Connecting to the data sources, identifying the required data for the analysis, inspecting the data to ensure it meets requirements, and identifying which data sources can provide the required data |
| Which of the following storage modes will copy data to Microsoft Power BI? | Import mode and dual mode |
| Which of the following are the benefits of using a shared dataset? | Dataset can scale as the organization grows, dataset is accessible from both office and remote, the dataset acts as a single source of truth |
| True or False: A shared dataset is more secure than a local dataset. | False |
| Which of the following data profiling tools allows you to inspect the percentage of valid, error, and empty data in a column? | Column Quality |
| You’re preparing a dataset for import into Microsoft Power BI and have accidentally changed a column to the wrong data type. What are the next actions you can take to correct the mistake? | Remove the step from the Applied Steps list and edit the changed type step in the applied steps list |
| True or False: Column profile displays the minimum and maximum values within the first 1000 rows for a specific column. | True |
| You are importing a dataset of 10 rows that contains a Date type column. One of the values in the Date column is Bicycle. Can you replace the value using the replace errors feature? | Yes |
| You are importing a dataset of 10 rows that contains a Date type column. One of the values in the Date column is Bicycle. Will column quality show 10% of values as error? | Yes |
| You are importing a dataset of 10 rows that contains a Date type column. One of the values in the Date column is Bicycle. Will column profile show 10% of values as error? | No |
| True or False: Distinct values refer to the number of values that only occur once in the dataset. | False |
| You have two tables of data: Sales and Product. Each row in the Sales table is associated with one of the bicycles in the Product table. Which of the following cardinalities is most suitable between the Sales and the Product table? | Many-to-one |
| 2 tables of data: Stock & Product. If a product is not in stock, it is not in the Stock table for the product. Merge the tables into 1 table to show products that are in stock. Stock = left table and Product = right table, which join types should you use? | Inner Join or Left Outer Join |
| True or False: When performing an append query, the columns of both tables must be the same. | False |
| You are importing a data source containing two columns: SalePrice and Cost. You need to create a calculated column to represent the Profit. Which of the following DAX queries will achieve the desired result? | Profit = SalePrice - Cost |
| True or False: Reducing columns and rows will reduce the required storage space for a table. | True |
| You are formatting the column properties of your data tables within your data model. In which section of Properties can you change the data type of the column? | Formatting |
| How many table storage modes does Microsoft Power BI Desktop support? | Three. Import, DirectQuery, and Dual |
| True or False: The DAX CALENDAR function automatically detects the data range of your dataset and creates a calculated date column. | False |
| Which of the following components of Microsoft Power BI allow you to add a description about your table? | Power Query Editor and Model View |
| True or False: If your data model does not contain a date table, you will not be able to perform time intelligence calculations using DAX. | False |
| Which languages can you use to create a common date table in Microsoft Power BI? | Python, DAX, and M |
| Adventure Works' US sales manager wants insights into the sales of a few states, and she asked you to present the sales and profit for California and Arizona only. What DAX functions can you use to compute the measures? | CALCULATE, SUMX, and FILTER |
| The profit margin is an example of what kind of measure? | Non-additive |
| You are handling a semi-additive measure in Microsoft Power BI. What DAX functions are useful in managing a semi-additive measure? | LASTNONBLANK, FIRSTDATE, and CALCULATE |
| Adventure Works wants a visualization displaying the opening balance of its products in stock for each month. Which DAX function is most suitable to use in computing your measure? | FIRSTNONBLANK |
| True or False: In Microsoft Power BI, you do not need to write DAX script to visualize implicit measures on the report canvas. | True |
| What is the maximum number of levels you can create in a hierarchy in Microsoft Power BI? | 5 |
| Can you create data hierarchy in Microsoft PBI by adding fields to the visual axis well? | Yes |
| Can you create data hierarchy in Microsoft PBI by using the power query editor? | No |
| Can you create data hierarchy in Microsoft PBI by creating a new hierarchy and adding fields to the hierarchy? | Yes |
| Can you create data hierarchy in Microsoft PBI by using DAX? | Yes |
| True or False: In Microsoft Power BI, you can only create calculated tables using DAX. | False |
| Microsoft Power BI’s Q&A visual lets users ask user-defined questions about the data. To help them swiftly analyze information and draw insights, what features of the Q&A visual can you configure? | Synonyms, Teach Q&A, and Relationships |
| True or False: When you write your question in the Q&A visual text box, Microsoft Power BI provides you with autocomplete suggestions. Can you modify the suggestions that appear in the Q&A visual? | True |
| In addition to using DAX to create calculated tables, what is an alternative way to create calculated tables without using any external tool? | M Language |
| You have Sales and Cost columns in your data table. The data type of the columns is set to Text. Which Microsoft Power BI element allows you to update the data types of the columns to Currency? | Report view, query editor, model view, and data view |
| How does the Performance Analyzer assist in analyzing user interactions in Microsoft Power BI reports? | By capturing the impact of user interactions on report elements. |
| What is the primary benefit of correctly categorizing the location-based columns of your data model in Microsoft Power BI? | To enable accurate geographical analysis and mapping |
Created by:
vhebert77
Popular Standardized Tests sets