Analytics-DA-201 Exam Results

In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.

Which function should the analyst use to remove the trailing spaces from the Category field?

You have the following dataset.

You want to create a new calculated dimension field named Category that meets the following conditions:

. When Subject is Computer Science or Science, Category must be Sciences.

. When Subject is English or Social Studies, Category must be Humanities.

Which two logical functions achieve the goal? Choose two.

A Data Analyst is using containers on a dashboard.

How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?

A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:

EmployeeInfo is the first table that is dragged to the canvas,

The records must contain the Full Name, and the Department Name, Size, and VP fields if available,

Not all records have an exact match.

Which type of join should the analyst use?