You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?

• A.Split the model into multiple models.
• B.Hide unused columns in the model.
• C.Merge tables by using Power Query.
• D.Transpose.

Comment: *

Name: *

Email: *

Verification: *

You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format:
2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?

• A.Apply a transform to extract the first 11 characters of the Logged column.
• B.Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
  .
• C.Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
• D.Change the data type of the Logged column to Date.

Comment: *

Name: *

Email: *

Verification: *

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.

You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?

• A.Add a duplicate query named Airline.
• B.Add airline as a synonym of carrier.
• C.Rename the carrier column as airline in the Carriers query.
• D.Rename the query from Carriers to airlines.

Comment: *

Name: *

Email: *

Verification: *

You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?

• A.Create a security role that has a table filter on the Sales_Manager table where username = UserName()
• B.Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
• C.Create a security role that has a table filter on the Sales_Manager table where name = UserName().
• D.Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Comment: *

Name: *

Email: *

Verification: *