Brainscape's Knowledge GenomeTM

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


See full index

Second attempt PL-300 > 3. Model data with power BI OK > Flashcards

3. Model data with power BI OK Flashcards

1
Q

Is it rue or false:

ALL () Removes all filters everywhere and can only be used to remove filters not to create a table.

A

True

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

What of the following are the two correct statement for RELATED

  1. Required that a relationship occurs between the current table with table with related information
  2. You always have to work with DATE-ADD
  3. It is a like V-look up
A

1 to 3

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

Select two true statement of COUNTA

  1. Not support boolen data type
  2. Returns a whole number
  3. Counts the number of rows in a specified column that contains non-blank values
  4. It is the same as count
A

2 and 3

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

True or false
DATEADD compare data along a period of time

A

True

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

True or false
Last not blank you can retrieve the first filled row date

A

False
Retrieves the first one

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

With quick measures you can solve problems without the use of use of DAX

True or false

A

True

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

DIfference between CALENDAR And CALENDAR AUTO

  1. Both set start and end automatically
  2. Both set star and end specifically
  3. CALENDAR set start and end specifically and CALENDAR AUTO automatically
A

3.

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

True or false

MMMM Is a user defined date/time that shows the month as a full month name

A

true

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

FILTER

Return a calculated column that represents a subset of anothe table of expression

True or false

A

False

Filter returns a table

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

What Dax Formula returns the user email address using a Dynamic role level security that will compare the user email address to that in employee table

A

userprincipalname

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

SUMX
When we want to able to calculate row level

1.YES
2. No

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

Quick insights don’t work with

1 Direct query
2. Streaming
3. Pushdatasets
4. 1,2
5. 1,2,3

A

5.1 2 3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
  1. A member can publish and change permission for the apps
  2. A contributor can publish reports to the workspace and delete content
  3. 1 false, 2, True
  4. 1 false 2 false
  5. 1 true 2 True
  6. 1 True 2 False
A
  1. 1 true 2 True
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Power BI User admin

  1. Create and manage user groups
  2. Reset user passwords
    3, Manage workplaces
  3. 1 and 3
  4. 1 and 2
A

5, 1 and 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q
  1. Billing Admin Cannot manage subscriptions
  2. Power Platform admin can enable and disable Power bi features
  3. 1 true 2 true
    1. False 2 true
  5. 1 true 2 false
    1. false 2 false
A
  1. false and true
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Is PATH function is used to creat a hierarchy

  1. True
  2. False
A
  1. true
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Sensitivity labels to a report are:

Power BI automatically applies tha label to the exported file and protects it according to the labels file

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

Data size limitations for R

Data used by the R visual is limited to 150.000 rows
the input data has a limit of 250 MB

True or false

A

True

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

Count rows refers to a table
it count The # of what in a specific table

  1. Rows
  2. Columns
  3. Measures
  4. calculated measure
A

1

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

What is the second parameter in the DAX functions PATHITEM

  1. the name of the field you are interested in
  2. Type
  3. the level you want to be returned
  4. the text path describing the hierarchy
A

3

PATHITEM takes two mandatory parameters: the first is the text path describing the hierarchy, and the second is the level we want to be returned.

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

Power BI provides two ways to endorse your datasets:

Promotion – Promote your datasets when they‘re ready for broad usage. Power BI Admins have permissions to promote datasets.

Certification – Request certification for a promoted dataset from an admin user that is defined in the Dataset Certification tenant admin setting. This certification adds another layer of security for your datasets.

yes or not

A

yes

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

Is dataflow

1Power Query Online
2Create reusable transformation logic that can be shared by many semantic models and reports inside Power BI.
3. 1 true
4. 2 true
5. 1 and 2 true

A

1 and 2 true

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

Rearrange the remaining order of steps to flatten out the JSON file into a Power BI table.

  1. Convert to Table
    Expand the Column
    Expand Purchase Lists to New Rows
    Expand Purchase Records to New columns

2 Expand the Column
Expand Purchases Lists to New columns
Expand Purchase Records to New columns
Convert to Table

Expand the Column
Expand Purchase Lists to New Rows
Expand Purchase Records to New columns
Convert to Table

A

1

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

You have a Power BI report that contains multiple visuals and is accessed by users in a shared capacity environment. Users have reported slow performance when interacting with the visuals. What should you recommend to improve the performance of the report?

Optimize the DAX calculations and formulas used in the report.

Yes or not

A

Not

Increase the shared capacity resources allocated to the App workspace.

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

For Analysis Services or Azure Analysis Services lives connections, you configure row-level security in the model, in Power BI.

False
True

A

False

Not in Power BI in Azure analysis service

26
Q

Which of the following options is not a privacy level in Power BI desktop?

A. Private
B. Public
C. Organizational
D. Confidential

A

d

27
Q

Which of the following statements are true for dashboards and reports?

A. Dashboards can have only a single page while reports can have multiple pages
B. Reports can have only a single page while Dashboards can have multiple pages
C. Both Dashboards and Reports can have multiple pages
D. Both reports and dashboards can be refreshed to display the latest data
E. Dashboards can be refreshed to display the latest data while the reports can’t
F. Reports can be refreshed to display the latest data while the Dashboards can’t

A

A and D

28
Q

How can you create a measure in Power BI?

Use the Power BI Desktop
Use the Power BI Service
Use the Power BI Mobile App
Use Excel

A

Use the Power BI Desktop
Use the Power BI Service

29
Q

What is the best way to manage your assets‘ access and permissions?

  1. Use Azure Active Directory
    2.Use Azure Role-Based Access Control
    3.Use Azure Security Center
    4.Use Azure Policy
A

2

30
Q

How can you create a relationship between two tables in Power BI?

1.Use the Manage Relationships dialog box
2 Use the Query Editor
3 Use the Data Model view
4. Use the Visualizations pane

A

1
It is the primary choice

31
Q

You need to create a data source that can be used by Power Apps. Which type of data source should you use if you need to store large amounts of data?

1.SQL Server
2.Common Data Service
3.SharePoint
4.OneDrive

A

1

SQL Server is a relational database management system that is designed to handle large amounts of data

32
Q

How can you ensure that your assets are backed up and recoverable in case of a disaster?

Use Azure Backup
Use Azure Site Recovery
Use Azure Disaster Recovery
Use Azure Storage Account Replication

A

Use Azure Backup

33
Q

What is the best way to monitor the performance of your assets?

Use Azure Monitor
Use Azure Log Analytics
Use Azure Application Insights
Use Azure Network Watcher

A

Use Azure Monitor

34
Q

How can you ensure that your assets are highly available and scalable?

Use Azure Availability Zones
Use Azure Virtual Machine Scale Sets
Use Azure Load Balancer
Use Azure Traffic Manager

A

Use Azure Availability Zones

35
Q

What is the most effective way to manage your assets‘ configuration and updates?

Use Azure Automation
Use Azure Configuration Management
Use Azure Policy
Use Azure Update Management

A

Use Azure Update Management

36
Q

How can you filter data in Power BI?

Using slicers
Using drill-through filters
Using cross-filtering
Using calculated columns

A

Using slicers

37
Q

How can you create a drill-through report in Power BI?

Use the Drillthrough feature in the Power BI Desktop
Use the Drillthrough feature in the Power BI Service
Use the Drillthrough feature in the Power BI Mobile App
Use the Drillthrough feature in Excel

A

Use the Drillthrough feature in the Power BI Desktop

38
Q

Your company is considering Power BI Report Server and you are asked if certain features are available.
Which of the following three features are NOT available in Power BI Report Server?

  1. Dashboards
    2.Paginated reports
    3.Q&A
    4.Quick insights
  2. Row-level security (RLS)
A

1
3
4

39
Q

What is assume referential integrity

Assume Referential Integrity enables running more efficient queries against your DirectQuery data source. However, for referential integrity to work, data in the From column in the relationship can never be null or blank.

Yes or not

A

Yes

40
Q

You are a Power BI consultant and you are doing some remote work for a mining company in Western Australia. You need to build a date table that starts from November 2010 and ends in December 2025. You decide you will use DAX to create a table.
How should you create the DAX expression?

1DATE ( 2010/11/1, 2025/12/31)
2CALCULATE( CALENDAR(‘ 2010/11/1’, ‘2025/12/31’) )
3CALENDAR( DATE(2010,11,1), DATE(2025,12,31) )
4 CALENDAR( 2010/11/1, 2025/12/31)

A

3CALENDAR( DATE(2010,11,1), DATE(2025,12,31) )

41
Q

1TRIM function. TRIM is used to remove whitespaces in strings.
2VALUE function. VALUE converts a number to a string
3CONCATENATE function. CONCATENATE joins two strings together.

A. 1. True 2 false 3 true
B all false
C all true
D 1. Flase 2 true False

A

A. VALUE converts a string to a number

42
Q

One of your queries in Power Query Editor seems to be taking a lot longer to refresh than you expect. You need to understand what Power Query is doing at authoring and at refresh time.
How would you go about this?

Run Performance Analyzer
Run Q&A
Run Query Diagnostics
Run the ALM toolkit

A

Run Query Diagnostics

43
Q

Your company is looking to expand your Power BI resources. Some of the feedback from your team is that it is hard to test Power BI Service dashboards fully prior to release. Is there a better way to handle the lifecycle of your Power BI report and dashboard creation?
What is the best solution to achieve this goal?

1 Install Power BI Report server to test reports
2 Create a deployment pipeline across development, test and production stages
3 Create separate workspaces for your team across the reporting lifecycle
4.Change to paginated reports for your reporting lifecycle

A

2 Create a deployment pipeline across development, test and production stages

44
Q

What is the file format used to define a theme for a Power BI report?

1.Cascading Style Sheets (CCS)
2. JavaScript Object Notation (JSON)
3. Extensible Markup Language (XML)
4. Power BI Markup Language (PBIML)

A
  1. JavaScript Object Notation (JSON)
45
Q

By default, which filter level behaves the same as a slicer in a report in Power BI Desktop?

Visual level filter
Report level filter
Page level filter
Query level filter

A

Page level filter

When you create a slicer in a report, the slicer will filter the visualizations on the current page, similar to page level filter.

46
Q

Which feature allows different users to view the same report but access different subsets of data?

Office 365 Groups
Two factor authentication
Row-level security
Query folding

A

Row-level security

47
Q

You encounter the 1 GB size limitation when uploading and refreshing your PBIX files. What is one way to work around this limitation?

1 Use the SUMMARIZE function in your DAX measures
2 Convert to DirectQuery for your data connections
3 Migrate your source database to Azure SQL database
4Turn on run-length encoding and compression in the DAX storage engine

A

2 Convert to DirectQuery for your data connections

Queries are pushed to the data source, and only the results are transferred to the Power BI Service for visualization.

48
Q

The DAX function USERPRINCIPALNAME(), returns the user’s email address e.g. John.Smith@ABCHospital.com. When the DAX function sets the email address = USERPRINCIPALNAME(), we are using a dynamic row-level security method that will compare the user’s email address to that in the employee table. This will then restrict the data that can be seen

Yes
Not

A

Yes

49
Q

some datasets can‘t generate insights because the data is statistically significant.

Yes or not

A

no

50
Q

What is the purpose of data aggregation?

To combine data from multiple sources
To remove outliers from the data
To replace missing data with estimated values
To transform data into a different format

A

To combine data from multiple sources

51
Q

Which of the following is the right DAX function to modify a single directional relationship to a bi-directional relationship on the fly (within the measure)?

A. TREATAS
B. USERELATIONSHIP
C. CROSSFILTER
D. RELATEDTABLE
E. RELATED

A

C

52
Q

SKIP and DENSE are Ranks formula argument

Skip The next rank value, after a tie, is the rank value of the tie plus the count of tied values. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 16 (11 + 5).

This is the default value when ties parameter is omitted.

Dense The next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 12.

Yes or not

A

Yes

53
Q

The PATH function is used to create a hierarchy.

Yes or not

A

Yes

54
Q

Direct Query storage tables can act as either cached or not cached, depending on the context of the query that‘s submitted to the Power BI datase.

Yes or not

A

Not

Dual

55
Q

You work for a consulting company that has a contract with a large government department. Part of the requirements for the report is to configure the page for use with a screen reader for sight-impaired users.
What should you configure in your report such that the page follows a logical sequence?

Bookmarks
Tab order
Filters on all pages
Layer order

A

Tab order

The tab order is used by keyboard users to navigate the report page. Screen reader and accessibility software follow the sequence of tab order

56
Q

You work for a share trading software company and have a dashboard for user trading times. The data set used for the analysis goes back seven years.
When the data reloads, it takes excessive time as the full seven years are refreshed.
How can you improve the dataset performance?

1Use an on-premises data gateway
2Configure incremental refresh in Power BI Desktop and enable it in Power BI service
3Enable incremental refresh directly in Power BI service
4 Manually refresh the database when users are not active

A

2 Incremental refresh must first be configured in Power BI Desktop.

57
Q

The DISTINCT() function returns a one column table that contains the distinct (unique) values in a row

Yes or not

A

not

The DISTINCT() function returns a one column table that contains the distinct (unique) values in a Column

58
Q

Variables and a return statement are used to improve the performance and readability of DAX expressions

Yes or not

A

yes

59
Q

The DISTINCT() function don’t return a one column table that contains the distinct (unique) values in a column.

True or False

A

False

the DISTINCT returns one column table

60
Q

What type of expression supported by Power BI while extracting data?

SQL, MDX, DAX
SQL, Python, R
SQL, DAX, M

A

SQL, DAX, M

61
Q

Live Connection: This technology allows a data visualization tool like Power BI to directly access and query data from a source database without copying the data into the BI tool itself. This reduces storage requirements and ensures users are always working with the latest data.

Yes or not

A

Yes

Second attempt PL-300 (5 decks)

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