Free Microsoft Power BI Certification (PL-300) Practice Test 14

In the visual, the Order Date in the Values well uses the Power BI auto date/time generated hierarchy (Year, Quarter, Month, and Day). You have to replace the Year, Quarter, Month & Day columns with a single Date column without breaking the visual.
Which of the following solutions would you use?

Select 1 option(s):

You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.
Based on the given scenario, choose the correct set of options:
How do you combine the Customer & the Sales table?

What join kind would you perform? (Assume Sales is the right table)

What would you do to the original two queries?

You choose Append Queries as New, Right Anti, & Delete them
Does the solution solve the problem?

Select 1 option(s):

You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.
Based on the given scenario, choose the correct set of options:
How do you combine the Customer & the Sales table?

What join kind would you perform? (Assume Sales is the right table)

What would you do to the original two queries?

You choose Merge Queries, Left Outer, & Leave them untouched
Does the solution solve the problem?

Select 1 option(s):

You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.
Based on the given scenario, choose the correct set of options:
How do you combine the Customer & the Sales table?

What join kind would you perform? (Assume Sales is the right table)

What would you do to the original two queries?

You choose Merge Queries as New, Left Anti, & Disable Enable Load
Does the solution solve the problem?

Select 1 option(s):

You have a list of customers in an Excel spreadsheet and a Sales table in on-premises SQL Server. You need to combine the two into a single table of only the customers who have not purchased any product. Finally, load this data into Power BI. Ensure that you minimize the size of the data model.
Based on the given scenario, choose the correct set of options:
How do you combine the Customer & the Sales table?

What join kind would you perform? (Assume Sales is the right table)

What would you do to the original two queries?

You choose Merge Queries as New, Left Anti, & Disable Include in report refresh
Does the solution solve the problem?

Select 1 option(s):

Given below is an incomplete M query. Choose the correct options that complete the M query to accomplish the required task.

Select 1 option(s):

There is a project requirement to extract and modify the above column names (in camel case) as shown in the table below.

Select and reorder the steps you would perform that meet the requirement.

Select 1 option(s):

Overview:
AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.
The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.
Below is the data model created by the company’s data warehouse engineers that you import from SQL Server into Power BI.
Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI. In this visual, you:
1. Move Yearly Income field into the Analyze well
2. Move Education field into the Explain by well
However, you get the below warning message.
How would you fix this warning?

Select 1 option(s):

Overview:
AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.
The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.
Below is the data model created by the company’s data warehouse engineers that you import from SQL Server into Power BI.
Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.
How would you configure the above key influencer visualization in each of the three wells?

Select 1 option(s):

Overview:
AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.
The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.
Below is the data model created by the company’s data warehouse engineers that you import from SQL Server into Power BI.
Q] From your data analysis, you find that the employees in AI Rudder interact with more male customers than female customers. So, to know the drivers of high incomes for male customers, you create the below measure:
Yearly Income (Male) =
CALCULATE ( SUM ( Customer[Yearly Income] ), Customer[Gender] = “M“ )
And, use this measure in the Analyze well.
But the Key influencers visual doesn’t find any influencer. How would you fix this issue?

Select 1 option(s):

Overview:
AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.
The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.
Below is the data model created by the company’s data warehouse engineers that you import from SQL Server into Power BI.
Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.
In the above chart, Australia comes next to the US in terms of Average of Yearly Income and has a much higher average income than the average income of other countries.
What could be the reason behind Australia not being considered a key influencer?

Select 1 option(s):

Overview:
AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.
The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.
Below is the data model created by the company’s data warehouse engineers that you import from SQL Server into Power BI.
Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.
You want to analyze how the number of customer purchases/orders influence their Yearly Income. What would you do?

Select 1 option(s):

Overview:
AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.
The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.
Below is the data model created by the company’s data warehouse engineers that you import from SQL Server into Power BI.
Q] To find the drivers of high incomes for your customers, you create the below key influencer chart in Power BI.
What does $44.29K in the blue circle indicate?

Select 1 option(s):

Overview:
AI Rudder is an AI startup that develops AI-powered voice solutions to improve B2C communications. The company has just received its Series B funding and is poised for growth.
The company uses its database of customers to target high-income earners in the US. It plans to understand the factors of high incomes and use these attributes to target potential customers.
Below is the data model created by the company’s data warehouse engineers that you import from SQL Server into Power BI.
Q] You analyze how the number of cars owned by the customer influences their Yearly Income. The below chart indicates that as the number of cars owned goes up by 0.78, the average income goes up by 6.8K.
What does 0.78 indicate?

Select 1 option(s):

Select 1 option(s):

Select 2 option(s):

Select 3 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Name of the display folders that are being used to organize the fields

Select 4 option(s):

Select 1 option(s):

Select 1 option(s):

Select 3 option(s):

Select 2 option(s):

Select 1 option(s):

Select 3 option(s):

Select 1 option(s):

Select 1 option(s):

Select 4 option(s):

Select 2 option(s):

Select 1 option(s):

Employee_id, Department_id, Department_name, Payment.
Created a report with a stacked bar chart showing the number of employees by department name.
Now you want to customize the information in the chart visualization tooltip.
In this case, what is the first step you need to take?

Select 1 option(s):

Select 2 option(s):

Select 2 option(s):

Select 1 option(s):

1. Train an MVAD model.
2. Create an Anomaly Detector resource that supports MVAD on Azure.
3. Query the status of your model.
4. Prepare your data.
5. Retrieve and interpret the inference results.
6. Detect anomalies with the trained MVAD model.

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 2 option(s):

Select 1 option(s):

Select 1 option(s):

Select 2 option(s):

Select 1 option(s):

Which of the following is the correct way to create such a metric?

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 1 option(s):

Select 2 option(s):

Select 1 option(s):

Select 1 option(s):