Linkedin Learning Introduction to Career Skills in Data Analytics Certification Answers 2024

Related Articles

Saylor Academy ESL002: Intermediate English as a Second Language Exam Answers

2 hours ago

Saylor Academy ESL001: Elementary English as a Second Language Certification Answers

20 hours ago

Career Essentials in Business Analysis by Microsoft and LinkedIn Exam Answers 2024

24 hours ago

Linkedin Learning Introduction to Career Skills in Data Analytics Certification Answers 2024

FINAL EXAM ANSWERS :

Question 1 of 40
An “Orders” table has 30 columns, and the report only needs the order total by date. Which transformation should you perform?

Select an answer:

Filter the order amount field to not include blanks, and group by using the date column.
Remove the other columns. Group by using the date column and aggregate the appropriate total field.–
Remove the other columns, and sort the date as descending.
Change the order total field data type, and remove the other columns.

You’re creating a PivotTable and a number field titled “ProductID” defaults to the SUM aggregate function. Which transformation can you apply so that it defaults to COUNT instead of SUM?

Select an answer:

Change the value to COUNT in the Value Field Settings.–
Pivot the data by the ProductID field.
Convert the value to a string.
Change the data type to a fixed decimal point.

Question 3 of 40
Your boss requests that you create a dashboard that includes a visual for your company’s annual sales, with months by top 10 products. Which visualization would not be appropriate?

Select an answer:

bar chart
line chart
column chart
KPI–

Question 4 of 40
What can be customized to provide more insights into a visual when you hover over items?

Select an answer:

conditional formats
legends
tooltips-
title

What is not a type of cardinality?

Select an answer:

one-to-one
one-to-many
many-to-many
one-to-none–

Question 6 of 40
You are working with two tables, called “Products” and “Freight Cost,” to develop a new report. The report should return a data set that includes all products and their associated freight costs, including those products that have zero freight costs. However, you notice that the report is only returning the products with positive freight costs associated. The report appears to be missing products, although they do exist in the “Products” table. What could be causing this?

Select an answer:

Freight ID is matched to Shipping ID.
The Join type is set to Inner.–
There is no Join between the tables.
The Join type is set to Cross.

Question 7 of 40
When you desire a unique count, which function should you use?

Select an answer:

Sum
Count
Unique Count
Distinct Count–

Question 8 of 40
Your “Subtotal” field is showing as left aligned and without a currency symbol. What is likely the issue?

Select an answer:

The field is formatted as a percent.
The field is formatted as text.–
The field is formatted as a number.

Question 9 of 40
When a field does not show the type of data that you need, what transformation will you perform?

Select an answer:

Replace the values to fit.
Duplicate the field and change the data type.
Change the field name.
Change the data type.–

Question 10 of 40
The leadership of an organization has commissioned a study on data about the sales team. The goal of the project is to determine top performers and their attributes. After gathering data and establishing basic rules and requirements, what is the most reasonable question to explore first?

Select an answer:

Who are the top performing suppliers?
Who are the top performing salespeople for any given point in time?–
What is the overall cost of a product?
What are the top performing products?

Question 11 of 40
You need to create a field that provides the value “over” or “under” for sales, depending on whether the amount is greater than or equal to 15,000. Which type of function can you write to create this data?

Select an answer:

logical functions, such as IF, CONDITIONAL COLUMN, or IIF–
lookup functions, such as XLOOKUP, VLOOKUP, or HLOOKUP
string functions, such as CONCAT, MERGE, or REPLACE

Question 12 of 40
The monthly payroll system contains every pay period from the start of the year and is updated weekly. This data will be used to write a weekly payroll report. However, when working with the data, the date field for payroll date does not appear to have a date hierarchy. What is most likely?

Select an answer:

The payroll date needs to be converted to weekly values.
The data for the payroll date is missing.
The payroll date can be transformed to show the year.
The data type for the payroll date is not set to a date data type.–

Question 13 of 40
There is a “Full Name” field with last name and first name separated by a comma. How can you parse the field into “Last Name” and “First Name” fields?

Select an answer:

=LEFT(Full Name, 10)
=Right(Full Name, 10)
Text to Columns–
=Concat(Full Name, Full Name)

Question 14 of 40
You are working with a data set including order records and their ID numbers. While profiling the data, you noticed that there are duplicate values in the “ID” field for each order. You need to create a data set that only shows one record per order, which would create a data set with distinct orders. What keyword can you include in the query to provide a unique list of orders?

Select an answer:

REMOVE DUPLICATES
DELETE
DISTINCT–

Question 15 of 40
A company is looking into increasing their margins on a product. Which variable(s) could be taken into consideration?

A) Product Cost
B) Product Retail Price
C) Customer Location

Select an answer:

customer location only
product retail price only
product cost and product retail price–
product cost only

Question 16 of 40
An organization has a table visual with customer and total sales data. They want to be able to see each product ordered by the customers, as well as expand/collapse various customers when using the visual. Which process would provide this solution?

Select an answer:

Add a second sales field to the values section.
Ensure that the sales field is above the customer field in the values section.
Add a second table with the same fields.
Convert the visual to a matrix with the product transactions field in both the rows and values.–

Question 17 of 40
You have a quarterly sales data set that contains a date field, with each business day written as a value for orders placed on that day. You need to find the days on which sales did not occur, and you do not have every day of the time period in your data. What should you introduce into your model?

Select an answer:

Add a date table joined to the data set. The join should provide all dates in the time period and the associated records.–
Create calculations that look for dates that don’t exist, and then provide the next date needed.
Inform the leadership that this report is not possible.
Open the data set and add records that represent the dates that are not present in the data set.

Question 18 of 40
When data in a software system is considered the most valid record and represents the truth of data, how would you classify that data?

Select an answer:

none of these answers
data warehouse
system of record–
source record

Question 20 of 40
For an organization to be truly data-informed and make data-driven decisions, which option(s) would give them the full picture of their data?

A) spreadsheets
B) business intelligence
C) business analytics
D) data analytics

Select an answer:

A, B, and C
A, B, C, and D
A
B, C, and D–

Question 22 of 40
When modeling data in Power BI, which process can help the data analyst, but should not be relied upon until it’s proven trustworthy?

Select an answer:

Use the Auto Redirect Relationships feature.
Assume all relationships are active.
Use the Auto Detect Relationships feature.–
Assume referential integrity for all join types.

Question 23 of 40
As a data analyst, what is the term for detecting different trends and patterns to help improve overall performance?

Select an answer:

KPIs
business requirements
business analysis
business intelligence–

Question 24 of 40
A company has determined that October is the month when their sales are the highest. They are looking at providing discounts to increase their profits for the seasonal high-point. What other questions should drive this business decision?

Select an answer:

Is there a product that has a higher margin that sells more in October?
Is there more profit in October, or just more sales?
all of these answers–
How many years has October been the highest in sales?

Question 25 of 40
A report needs to show the number of weekdays within a project to estimate capacity. Which function would provide the desired result?

Select an answer:

WEEKDAY
NETWORKDAYS-
WORKDAY
DAYS

Question 26 of 40
A “City” field has some values written as uppercase and other values as lowercase, as well as inconsistent spellings. Which processes would create a field with uppercase values that are correctly spelled?

A) =TRIM
B) Replace Values
C) =UPPER

Select an answer:

B and C-
A and B
A, B, and C

Question 27 of 40
In using Power Query, you notice that a field of data is not joining with data that appears the same. You have already removed trailing and leading spaces. What cleaning command should you consider next?

Select an answer:

CLEAN–
TRIM
REPLACE ERRORS

Question 28 of 40
Conditional formatting is an example of _.

Select an answer:

modeling data-
cleaning data
transforming data

Question 29 of 40
A product has an updated weight value after a manufacture change, and the inventory report has an inconsistent total value for the calculated “Cost” field. What should be performed to resolve the issue?

Select an answer:

Create a calculation that subtracts the total value from the expected value.
Confirm the calculation is updated to reflect the change.–
Create a calculation that subtracts the updated weight value from the calculated cost field.
Create a calculated field that captures the difference between the total and expected value.

Question 30 of 40
Metrics that inform the business on the overall health of the organization, processes, or products are considered _.

Select an answer:

cards
KPIs (Key Performance Indicators)-
matrices
aggregated values

Question 31 of 40
A data analyst prepares a report from a monthly uploaded data set. However, in their initial profile of the data, one of the historically top-selling products is not included. Which action item would be best practice?

Select an answer:

Communicate with the person or team responsible for the dataset, letting them know that the product is missing.-
Add in the product details from last month.
Estimate the amount and place it in the data.
Submit the report with the current data.

Question 32 of 40
Power BI Report Builder and SSRS are both tools for _.

Select an answer:

dashboard reports
dashboards and paginated reports
paginated reports-
data modeling

Question 33 of 40
A quarterly report is created within Power BI using a dataset with four fields: Sales, Customer Name, Customer ID, and Salesperson. The report only needs to show three fields: Sales, Customer Name with the Customer ID (e.g. “Brakes and Shakes (15)”), and Salesperson. The customer field in the report includes the Customer Name and Customer ID. Which transformation can you use to create the “Customer Name (CustomerID)” field for the report?

Select an answer:

merging columns–
renaming columns
adding conditional columns
removing unnecessary columns

Question 34 of 40
The inventory dataset has a field for “Inventory ID.” The first two letters signify whether the inventory is received or not received, followed by a hyphen, and then the 5-digit ID number (e.g. IR-45322). For the inventory report, you want to create a calculation that only provides the numbers after the hyphen. Which function would give you only the digits from the Inventory ID?

Select an answer:

=Right (Inventory ID, 5)–
=Left (Inventory ID, 5)
=Trim (Inventory ID, 5)
=Search(Inventory ID, “-“, 5)

Question 35 of 40
Which option is a language in Power BI for creating the calculations in Quick Measures?

Select an answer:

R
DAX–
SQL
M Code

Question 36 of 40
Which transformation can you use to remove leading and trailing spaces in a field?

Select an answer:

REPLACE VALUES
TRIM–
CONCAT
REMOVE ERRORS

Question 37 of 40
Which options are more flexible at storing data than a spreadsheet?

A. database
B. data warehouse
C. CSV (comma separated values)

Select an answer:

A and C
A, B, and C
B and C
A and B–

Question 38 of 40
An annual review of total compensation shows one total in the payroll database and a different total in the HR software. What should be your next step?

Select an answer:

Report using only the payroll database data.
Append the data from both the payroll and HR software data.
Report using only the HR software data.
Determine which system has the accurate value for total compensation (system of record).–

Question 39 of 40
When profiling a dataset for the first time, you note that a row is blank in the first column. What should be your first action?

Select an answer:

Keep the row.
Delete the row.
Confirm the row is empty.–
Promote the headers.

Question 40 of 40
Which process includes determining the volume of data, identifying basic information of the different field values, and uncovering basic transformation requirements in a data set?

Select an answer:

data transformation
data modeling
data cleaning
data profiling–