Free Analyzing Data with Microsoft Power BI Questions and Answers

Question 1

You launch Power Query Editor and open a query.
The percentage of empty values in each column must be rapidly determined.
Which Data Preview selection is best?

Accepted Answer

Column quality

Answer

Show whitespace

Answer

Column profile

Answer

Column distribution

Question 2

You have a list of potential clients with 1,500 rows of data. The following fields are included in the list:
- First name
- Last name
- Email address
- State/Region
- Phone number
The list is imported into Power Query Editor.
The list must contain data for every State or Region that you intend to target with a marketing campaign.
What are the two things you should do? Each right response offers a piece of the answer.
NOTE: There are two correct answers

Accepted Answer

Select Column distribution.

Answer

Select Column quality.

Answer

Enable Column profiling based on entire dataset.

Question 3

You have a custom connector that gives you the following information for each email sent in the last year: ID, From, To, Subject, Body, and Has Attachments. There are returned more than 10 million records.
Based on whom employees send emails to, you create a report that analyzes the internal networks of those employees.
You must keep the recipients of the report from viewing the examined emails. The model size must be reduced in the solution.
What ought you to do?

Accepted Answer

Remove the Subject and Body columns during the import.

Answer

From Model view, set the Subject and Body columns to Hidden.

Answer

Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Answer

None of the Above

Question 4

You have one of the three Azure SQL databases listed below:
- Test
- Production
- Development
You have a dataset that draws its data from the development database.
You must set up the dataset so that you can quickly switch between the powerbi.com development, test, and production database servers as the data source.
Which one is the best?

Accepted Answer

Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Answer

Create a parameter and update the queries to use the parameter.

Answer

Create a query for each database server and hide the development tables.

Answer

Create a JSON file that contains the database server names. Import the JSON file to the dataset.

Question 5

You have a CSV file with user complaints in it. The file has a column called Logged in it. Each complaint's log entry includes the date and time that it happened. The information in Logged is formatted as follows: 2018-12-31 08:59.
You must be able to use an internal date hierarchy and the logged date to assess the complaints.
What ought you to do?

Accepted Answer

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

Answer

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

Answer

Change the data type of the Logged column to Date.

Answer

Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

Question 6

You have a sales transaction database stored in Azure SQL. The database is regularly updated.
To find phony transactions, you must create reports from the data. After an update, the data must be accessible within five minutes.
How should the data connection be set up?

Accepted Answer

Set Data Connectivity mode to DirectQuery.

Answer

Set Data Connectivity mode to Import.

Answer

Add a SQL statement.

Answer

Set the Command timeout in minutes setting.

Question 7

You have a data model with a large number of intricate DAX expressions. The RELATED and RELATEDTABLE functions are frequently mentioned in the expressions.
You must offer a suggestion for how to use the RELATED and RELATEDTABLE functions less frequently.
What ought to you suggest?

Accepted Answer

Merge tables by using Power Query.

Answer

Transpose.

Answer

Split the model into multiple models.

Answer

Hide unused columns in the model.

Question 8

You are working with a sizable dataset that has more than a million rows. The table contains a Date datetime field. Without sacrificing data access, the data model needs to be shrunk. What ought you to do?

Accepted Answer

Divide the Date column into two columns: one with just the time and the other with just the date.

Answer

Round the Date column's hour to startOfHour.

Answer

The Date column's data type should be changed to Text.

Answer

Cut the Date column out.

Question 9

Four sales regions are available. There are several sales managers in each region. In a data model, you apply row-level security (RLS). You give each role access to the necessary distribution lists. You have sales reports that allow for regional analysis. The sales managers have access to their region's sales data. Records from other regions are hidden from the sales managers' view. A sales manager relocates to a new area. You must make sure the sales manager can get the accurate sales information. What should you do?

Accepted Answer

Request that the right Azure Active Directory group be added for the sales manager.

Answer

The sales manager's Microsoft Power BI license type should be changed.

Answer

Edit the reports' Row-Level Security option from Microsoft Power BI Desktop.

Answer

Control the underlying dataset's permissions.

Question 10

In a star schema with four tables named Sales, Customer, Date, and Product, you have sales data. Purchase and shipping dates are listed in the Sales table. Although you will most frequently utilize the purchase date, you may also examine the data using both dates separately and jointly. To support the analysis, you must create an imported dataset. The model size and number of queries against the data source must be kept to a minimum. What data modeling approach should you employ?

Accepted Answer

For the date of purchase, create an active relationship between Sales and Date, and for the date of shipment, create an inactive relationship.

Answer

Use Microsoft Power BI's Auto Date/Time feature instead of importing the Date table.

Answer

Use the Power Query duplicate of the Date query and the active relationships between the two Date tables.

Answer

Create active relationships between Sales and both Date tables in the modeling view using a reference query on the Date table in Power Query.