Q1. - (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) tabular project. 

You need to grant the minimum permissions necessary to enable users to query data in a data model. 

Which role permission should you use? 

A. Explorer 

B. Process 

C. Browser 

D. Administrator 

E. Select 

F. Read 

View Answer

Q2. HOTSPOT - (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team. 

The data warehouse used by the cube contains the time durations of taps run by each runner on the team. The time durations are stored in seconds as an integer. 

You need to build the following two measures in the cube: 

. A measure named Measure1 that must contain the average time duration of the laps run by each runner. . A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap. 

What should you do? To answer, select the appropriate Aggregation Function property for each measure in the answer area. 

View Answer

Q3. - (Topic 1) 

You need to recommend a solution to meet the requirements for the Manufacturinglssues.rdl report. 

What is the best solution that you should include in the recommendation? More than one answer choice may achieve the goal. Choose the BEST answer. 

A. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Add a dataset for each parameter created. Configure each parameter to use the values in the dataset. 

B. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer. 

C. Add a dataset to the report that uses an ad hoc SQL statement. Configure the dataset to include the parameters required for the different views. Use the default display for the parameters. 

D. Add a dataset to the report that uses a stored procedure. Configure the dataset to include the parameters required for the different views. Update each parameter to use a set of values from Report Designer. 

View Answer

Q4. - (Topic 4) 

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates mobile phone usage data from a Microsoft Azure SQL Database database. The existing database contains a device dimension. 

The Research and Development team has requested that capabilities be added to the database. 

The capabilities must meet the following requirements: 

... 

A device member must be able to have multiple capability members. 

A capability member must be able to belong to several device members. 

The Research and Development team must be able to create new capabilities 

every quarter in the data source. 

You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized. 

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Create a dimension named Capability Name and then configure a many-to-many relationship. 

B. Add an attribute hierarchy for each capability to the customer dimension. Configure each hierarchy to have two members named Yes and No. 

C. Create a dimension named Capability Name and then configure a regular relationship. 

D. Add an attribute hierarchy named Capability Name to the customer dimension. 

View Answer

Q5. - (Topic 3) 

You need to create the hierarchy in the AdhocReports project. 

What should you do? 

A. Multi-select all of the columns, right-click the columns, and then click the Create Hierarchy command. 

B. Use the RELATEDTABLEO function to consolidate the tables, multi-select the columns in the hierarchy, right-click the columns, and then click the Create Hierarchy command. 

C. Use the RELATEDO function to consolidate the columns in the DimSalesTerritory table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. 

D. Use the RELATEDO function to consolidate the columns in the DimEmployee table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. 

View Answer

Q6. - (Topic 4) 

You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a relational data source named DB1. 

You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1. 

What should you do? 

A. Register a Service Principal Name (SPN) for Server1. 

B. From the SQL Server Data Tools, modify the impersonation settings. 

C. From the Web.config file, modify the impersonation settings. 

D. Register a Service Principal Name (SPN) for DB1. 

View Answer

Q7. - (Topic 4) 

You are designing a SQL Server Reporting Services (SSRS) report. 

The report defines a single SQL Server data source and dataset. 

You need to include additional data sourced from a Microsoft Azure SQL Database database in the report. 

What should you do? 

A. Create a SQL Server data source and then add a dataset that uses the new data source. 

B. Create a Microsoft Azure SQL Database data source and then add a dataset that uses the new data source. 

C. Generate an Atom-compliant data feed for the report. 

D. Create a Microsoft Azure SQL Database dataset that uses the existing data source. 

View Answer

Q8. DRAG DROP - (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) cube. 

You need to add a calculated member to the Customer dimension to evaluate the sum of values for the United Kingdom and the United States. 

Which expression should you use? (To answer, drag the appropriate expression to the answer area.) 

View Answer

Q9. - (Topic 4) 

You are developing a tabular Business Intelligence Semantic Model (BISMJ database based on a SQL Server database. 

In the data source, the FactlnternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactlnternetSales table, in the DimProduct table, and in the DimCustomer table. 

In the model, the FactlnternetSales table is also partitioned by month. 

You need to ensure that the model has the most recent data while minimizing the processing time. 

What should you do? 

A. Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option. 

B. Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option. 

C. Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing option. Then process the database with the Process Recalc processing option. 

D. Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Defrag processing option. 

E. Process the latest FactlnternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option. 

View Answer

Q10. - (Topic 4) 

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design. 

The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes: 

Organization, which is a key attribute 

Organizations, which defines the parent-child hierarchy 

Currency Code, which is a regular attribute 

... 

. PercentageOfOwnership, which is a regular attribute 

When users browse the dimension, four hierarchies are visible to them. 

You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users. 

What should you do? 

A. Set the AttributeHierarchyVisible property to False for the Organization and PercentageOfOwnership attributes. 

B. Set the AttributeHierarchyEnabled property to False for the Organization and PercentageOfOwnership attributes. 

C. Delete the Organization and the PercentageOfOwnership attributes. 

D. Set the AttributHierarchyDisplayFolder property to Null for the Organization and PercentageOfOwnership attributes. 

View Answer