Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Finance > PL-300 > Flashcards

PL-300 Flashcards

Get PL-300 certified

1
Q

Which 3 objects can be pinned to a dashboard from a report?

A
  1. Custom visual
  2. Images
  3. Ribbon charts
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Where can you view alerts from reports?

A

Email & notification center

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

You need to add a visual to a power bi dashboard. This visual does NOT exist on a report in the workspace/ What should you do first?

A

Select Ask a question about your data. The Q&A feature lets you create a visual by typing in a question about your data. This new visual can then be pinned to the dashboard, without adding it to a report.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the number of consecutive refresh failures that will automatically disable the refresh schedule?

A

4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the maximum number of refreshes that can be scheduled each day when you have a Power BI Premium per user workspace?

A

48

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Gauge visual

A

Halve donut zoals in auto dashboard.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Ribbon chart

A

Hiring chart in consultimed dashboard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Key influencers visual?

A

Helps you understand correlated factors impacting a particular metric.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Constant line?

A

Either the X- or Y-axis constant line allows a DAX measure to be used to provide this value for the visual.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In PowerBI Desktop you need to create a role. Which two interfaces can you use?

A

Model view & Report view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

You plan to use the calculated table functionality to add a duplicate table in Power BI desktop. Which characteristics of the original table will be duplicated?

A

Data only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which type of DAX quick measure calculations will NOT work against a DirectQuery table?

A

time intelligence. Their functions have performance implications and are disabled for quick measures against DirectQuery tables. Mathematical operations, aggregate per category, and X-functions are all supported against DirectQuery.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a feature of an implicit measure that explicit measures do NOT have?

A

End-users can change the aggregation type of implicit measure from the Values well of a visual.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How can you reduce the cardinality of a column in a power BI dataset?

A

Reduce the number of distinct values.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does the PATH function in DAX do?

A

Returns a string with identifiers of all the parents of the current identifier, which is used for flattening.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does the PATHITEM function in DAX do?

A

Returns the item at the specified position of a string, which is also used for flattening.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What does the EXCEPT function do in DAX?

A

Returns rows from one table which do not appear in another table, which would require another table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What does the CROSSJOIN function do in DAX?

A

Returns a Cartesian product of all rows from all tables that the function references.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What does the IGNORE function in DAX do?

A

Modifies the behavior of the SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL evaluation.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What does the FILTER function do in DAX?

A

Returns a table that represents a subset of another table or expression.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

You plan to get data from flate files for a Power BI dataset. You need to select a location to store the files. Which location requires an on-premises data gateway?

A

Shared folder on a local network.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

You have a Power BI dataset that gets data from a table in a SQL Server database. From which view can you modify the storage mode of the table in PBI desktop?

A

Model view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

You need to minimize occurences of the timeout issues in SQL servers when creating a data source which uses a SQL SELECT statement. How?

A

Divide the SQL statement into separate data sources. This will minimize the amount of processing on the SQL Server side.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

How can you create a table in Excel?

A

Select the data you want to import, press CTRL+T or choose the Table button, click OK and save the change.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

You need to identify outliers in a text column within the data source of an imported excel file in power query editor. Which information should you use from the power query editor?

A

The top and bottom entries in Value distribution. They identify outliers, which appear, respectively, the greatest and the smallest number of times in that column.

26
Q

What does the distinct value in column profiling indicate?

A

The total count of different values.

27
Q

What does the unique entry in column statistics indicate?

A

The total count of different values that appear only once.

28
Q

Pivot column operation?

A

Converts data into a table by aggregating values in a column.

29
Q

Unpivot column operation?

A

Performs the opposite of pivot. Converts columns into rows.

30
Q

Dual storage mode?

A

Means that either an import query can be run when accessing data or a DirectQuery can be run when accessing data.

31
Q

Why is it sometimes smart to replace null with 0?

A

If the value stays null, the averages will not calculate correctly.

32
Q

In what circumstances should you combine tables into a single table?

A
  • Too many tables exist, making it difficult to navigate an overly complicated semantic model.
  • Several tables have a similar role.
  • A table has only a column or two that can fit into a different table.
  • You want to use several columns from different tables in a custom column.
33
Q

What are the join options and what do they do?

A

Left Outer = displays all rows from the first table and only the matching rows from the second.
Full Outer = Displays all rows from both tables.
Inner = Displays the matched rows between two tables

34
Q

What does column distribution show?

A

The distribution of the data within the column and the counts of distinc and unique values, both of which can tell you details about the data counts.

35
Q

What does the column profile show?

A

Gives you a more in-depth look into the statistics within the columns for the first 1000 rows of data. This column provides several different values, including the count of rows, which is important when verifying whether the importing of your data was succesful.

36
Q

What is a flat file?

A

A type of file that has only one data table and every row of data is in the same structure. The file doesn’t contain hierarchies. Common types are csv, txt and fixed width files or xlsx.

37
Q

Local file import?

A

The file isn’t moved into Power BI after import, and a link doesn’t remain to it. Instead, a new semantic model is created in Power BI, and data from the Excel file is loaded into it. Accordingly, changes to the original Excel file aren’t reflected in your Power BI semantic model. You can use local data import for data that doesn’t change.

38
Q

OneDrive for Business import?

A

This method is effective in keeping an Excel file and your semantic model, reports, and dashboards in Power BI synchronized. Power BI connects regularly to your file on OneDrive. If any changes are found, your semantic model, reports, and dashboards are automatically updated in Power BI.

39
Q

OneDrive - Personal import?

A

You can use data from files on a personal OneDrive account, and get many of the same benefits that you would with OneDrive for Business. However, you’ll need to sign in with your personal OneDrive account, and select the Keep me signed in option. Check with your system administrator to determine whether this type of connection is allowed in your organization.

40
Q

Sharepoint - Team Sites import?

A

Saving your Power Bi desktop files to sharepoint team sites is similar to saving to OneDrive for Business. The main difference is how you connect to the file from Power BI. You can specify a URL or connect to the root folder.

41
Q

Which 4 locations are there for Excel file imports?

A
  1. Local
  2. OneDrive for Business
  3. OneDrive - Personal
  4. Sharepoint - Team Sites.
42
Q

What would be a reason to choose OneDrive or Sharepoint Team Sites as a file location over Local?

A

Using cloud options is the most effective way to keep your file and your semantic model, reports, and dashboards in Power BI in-sync. However, if your data doesn’t change regularly, saving files on a local computer is a suitable option.

43
Q

What is a Dynamic report?

A

Reports in which the data can be changed by a developer according to user specifications. Dynamic reports are valuable because a single report can be used for multiple purposes. You’ll have fewer individual reports to create, which will save organizational time and resources. You can use parameters by determining the values that you want to see data for in the report, and the report updates accordingly by filtering the data for you.

44
Q

What is a NoSQL database? (aka non-SQL, not only SQL or non-relational)

A

A flexible type of database that doesn’t use tables to store data.

45
Q

What is Azure Cosmos DB?

A

A NoSQL database. Has its own connector for getting data under Azure. You need to enter your account key when connecting to an endpoint for the first time.

46
Q

What are the three different types of storage modes you can choose from?

A

Import, DirectQuery en Dual (Composite)

47
Q

DirectQuery storage mode?

A

Allows you to query the data in the data source directly and not import a copy into PowerBI. Is useful because it ensures you’re always viewing the most recent version of the data. Essentially a direct connection to the data source. Additionally, this mode is suited for when you have large semantic models to pull data from. Instead of slowing down performance by having to load large amounts of data into PBI, you can use DQ to create a connection to the source, solving data latency issues as well.

48
Q

Import storage mode?

A

Allows you to create a local PBI copy of your semantic models from your data source. You can use all PBI service features with this storage mode, including Q&A and Quick Insights. Data refreshes can be scheduled can be scheduled or on-demand. Import mode is the default for creating new PBI reports.

49
Q

Dual (composite) import mode?

A

In Dual mode, you can identify some data to be directly imported and other data that must be queried. Any table that is brought in to your report is a product of both Import and DQ modes. Using Dual mode allows PBI to choose the most efficient form of data retrieval.

50
Q

What is Azure Analysis Services?

A

A fully managed platform as a service (PaaS) that provides enterprise-grade semantic models in the cloud. You can use advanced mashup and modeling features to combine data from multiple data sources, define metrics, and secure your data in a single, trusted tabular semantic model. The semantic model provides an easier and faster way for users to perform ad hoc data analysis using tools like Power BI.

51
Q

What are the notable differences between Azure Analysis Services and SQL server?

A
  • Analysis Services models have calculations already created.
  • If you don’t need an entire table, you can query the data directly. Instead of using Transact-SQL (T-SQL) to query the data, like you would in SQL Server, you can use multi-dimensional expressions (MDX) or data analysis expressions (DAX).
52
Q

What are the similarities between Azure Analysis Services and SQL Server?

A
  • Authenticate to the server
  • Pick the model you want to use
  • Select which tables you need
53
Q

What is query folding?

A

The process by which the transformations and edits that you make in Power Query Editor are simultaneously tracked as native queries, or simple Select SQL statements, while you’re actively making transformations. The reason for implementing this process is to ensure that these transformations can take place in the original data source server and don’t overwhelm PBI computing resources.

54
Q

What are the benefits of query folding?

A
  • More efficiency in data refreshes and incremental refreshes.
  • Automatic compatibility with DirectQuery and Dual storage modes.
55
Q

For which transformation are native queries not possible?

A
  • Adding an index column
  • Merging and appending columns of different tables with two different sources
  • Changing the data type of a column
56
Q

What are techniques other than query diagnostics and query folding to optimize performance in PQ?

A
  • Process as much data as possible in the original data source
  • Use native SQL queries
  • Separate data and time, if bound together. This approach will increase compression abilities.
57
Q

What does the error query timeout expired mean?

A

Relational source systems often have many people who are concurrently using the same data in the same database. Some relational systems and their administrators seek to limit a user from monopolizing all hardware resources by setting a query timeout. These timeouts can be configured for any timespan, from as little as 5 seconds to as much as 30 minutes or more.

58
Q

What is the cost of calculated tables?

A

They increase the model storage size and they can prolong the data refresh time. The reason is because calculated tables recalculate when they have formula dependencies to refreshed tables.

59
Q

What does the CALENDARAUTO DAX function do?

A

Guarantees that the following requirements to mark a date table are met:
- The table must include a column of data type date
- The column must contain complete years
- The column must not have missing dates

60
Q

How do you create a date table?

A

Using the CALENDAR DAX function and passing in two date values, which represent the date range. The function generates one row for each date within the range. You can pass in static date values or pass in expressions that retrieve the earliest/ latest dates from specific columns in your model.

61
Q

Which are the 3 techniques that you can use to add columns to a model table?

A
  1. Add columns to a view or table (as a persisted column), and then source them in PQ. This option only makes sense when your data source is a relational database and if you have the skills and permissions to do so. However, it is a good option because it supports ease of maintenance and allows reuse of the column logic in other models or reports.
  2. Add custom columns (using M) to PQ queries.
  3. Add calculated columns (using DAX) to model tables.
62
Q
A

Finance (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions