Free Access Microsoft.070-768.v2022-01-19.q61 Practice Test (Page 12)

Question 51

Which is the easiest option for configuring and maintaining security for each salesperson?

A.Create one role for the salesperson group with a row filter on the Direct Sales table that uses the CUSTOMDATA function.

B.Create a role for each salesperson with a row filter restricting the user to a specific sales territory in the Direct Sales table.

C.Create a one role for the salesperson group with a row filter on the Direct Sales table that uses the CONTAINS and USERNAME functions to find the user's sales territory in the Salesperson table.

D.Create a permissions table, add it to the tabular model, and define a relationship between it and the Direct Sales table.

Question 52

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
- Queries must be able to return all rows.
- Must be able to support four different processing schedules for
different date ranges.
- Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.What should you do?

A.Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.

B.Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.

C.Create four partitions for the Sales table. Use row filter queries for each partition.

D.Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.

Question 53

A database named DB2 uses the InMemory query mode. Users frequently run the following query:

You need to ensure no users see the PriorYearSales measure in the field list for the Sales table.
What should you do?

A.Create a perspective, and ensure that the PriorYearSales measure is not added to the perspective.
Ensure that users connect to the model by using the perspective.

B.Set the Display Folder property for PriorYearSales toHidden.

C.Remove the PriorYearSales measure from the default field set of the Sales table.

D.Create a role using Read permissions, and define a DAX expression to filter out the PriorYearSales measure. Add all users to the role.

Question 54

DRAG DROP
You need to configure the SalesAnalysis cube to correct the sales analysis by customer calculation.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Question 55

How can you enhance the model to support analysis by date?

A.Create a date table in a new SQL Server database, and import it into the model by using the Table Import Wizard.

B.Create a calculated column in the Internet Sales and Direct Sales tables using the CALENDAR function on the InvoiceDate column.

C.Create calculated columns in the Internet Sales and Direct Sales tables to derive year, quarter, and month from the InvoiceDate columns.

D.Create a calculated table using the CALENDARAUTO function and add calculated columns to the calculated table to derive year, quarter, and month from the InvoiceDate columns.

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 156TheSecOpsGroup.CNSP.v2025-09-08.q20; 207CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 137Adobe.AD0-E605.v2025-09-05.q50; 181Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File