Vivid 70-466 Free Practice Questions 2021

NEW QUESTION 1
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 tabular model.
Which role permission should you use?

• A. Explorer
• B. Select
• C. Process
• D. Browser
• E. Read Definition
• F. Read

Answer: F

NEW QUESTION 2
You need to modify the Sales cube to support the planning requirements. Which SSAS feature should you use?

• A. A KPI
• B. A translation
• C. A perspective
• D. A writeback partition

Answer: D

NEW QUESTION 3
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique color scheme combination of foreground and background colors.
You need to ensure that all of the text boxes in the table headers use the correct business unit colors.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Add one report variable for Colo
• B. Assign it with an expression to return the appropriate color
• C. For each header text box, set the Color and BackgroundColor properties by using the variable.
• D. Add two report variables named Color and BackgroundColo
• E. Assign them with expressions to return the appropriate color
• F. For each header text box, use expressions to set the Color and BackgroundColor properties by using the variables.
• G. For each header text box, assign expressions to the Color and BackgroundColor properties.
• H. Add two Microsoft Visual C# functions to the code block of the report to implement Color and BackgroundColor function
• I. For each header text box, use expressions to set the Color and BackgroundColor properties by using the functions.

Answer: D

NEW QUESTION 4
HOTSPOT
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A role named USA allows users to browse data pertaining to the United States. A role named Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.

Answer:

Explanation:

NEW QUESTION 5
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a Microsoft Azure SQL Database database. The cube is processed each night at midnight.
The largest partition in the cube takes 12 hours to process, and users are unable to access the cube until noon. The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to satisfy the query.
Which three 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.)

Answer:

Explanation: Box 1:

Box 2:

Box 3:

Note:
* Processing mode has two possible options.
Regular. This is the default setting. When set to regular, partitions will be available to users after data has been loaded and aggregations are created completely.
Lazy Aggregations. When set to lazy aggregations, partitions will be available to user queries immediately after data has been loaded. Aggregations will be created as a separate background process while users start to query the partition.
* Lazy processing performs the task of building indexes and aggregations for dimensions and measure group partitions at a lower priority to reduce foreground processing time and to allow users to query the cube sooner. For lazy processing to occur, you must switch the ProcessingMode = LazyAggregations of your measure group partitions; by default this value is Regular (lazy processing is turned off). When processing a dimension with flexible aggregations such as parent-child or virtual dimension by using the processing enumeration of ProcessUpdate (such as to take into account of member name or hierarchy changes), lazy processing is initiated to ensure that the aggregations are rebuilt on the associated measure group partitions.
* Configure Lazy Processing for the cube, measure group, or partition. If you configure Lazy Processing, the dropped aggregations are recalculated as a background task. While the flexible aggregations are being recalculated, users can continue to query the cube (without the benefit of the flexible aggregations). While the flexible aggregations are being recalculated, queries that would benefit from the flexible aggregations run slower because Analysis Services resolves these queries by scanning the fact data and then summarizing the data at query time. As the flexible aggregations are recalculated, they become available incrementally on a partition-by-partition basis. For a given cube, Lazy Processing is not enabled by default. You can configure it for a cube, measure group, or partition by changing the ProcessingMode property from Regular to LazyAggregations. To manage Lazy Processing, there are a series of server properties such as the LazyProcessing MaxObjectsInParallel setting, which controls the number of objects that can be lazy processed at a given time. By default it is set to 2. By increasing this number, you increase the number of objects processed in parallel; however, this also impacts query performance and should therefore be handled with care.
* Incorrect: With Bring Online Immediately enabled, during cache refresh all queries are directed to the relational source database to retrieve the latest data for end users. While this provides users with refreshed data, it can also result in reduced query performance given that Analysis Services needs to redirect queries to the relational source database.

NEW QUESTION 6
You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

• A. A tabular project that uses the In-Memory query mode
• B. A tabular project that uses the DirectQuery query mode
• C. A multidimensional project that uses the MOLAP storage mode
• D. A PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
• E. A multidimensional project that uses the ROLAP storage mode

Answer: ABD

Explanation: Power View is a thin web client that launches right in the browser from a data model in SharePoint Server 2010. The model can be a PowerPivot model workbook or a tabular model running on a SQL Server 2012 Analysis Services (SSAS) server.

NEW QUESTION 7
DRAG DROP
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.)

Answer:

Explanation:

NEW QUESTION 8
You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?

• A. For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.
• B. For the dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.
• C. For the Customer Geography dimension, set the Processing Mode property to LazyAggregations.
• D. For the Customer Geography dimension, set the ProcessingPriority property to 1.

Answer: A

NEW QUESTION 9
You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Use your domain credential
• B. Grant least privilege to your account in the source database.
• C. Create and use a new Windows domain accoun
• D. Grant least privilege to this account in the source database.
• E. Use the credentials of the SQL Server Analysis Services (SSAS) service accoun
• F. Grant least privilege to this account in the source database.
• G. Use SQL Server authentication.

Answer: B

NEW QUESTION 10
You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string.
You need to configure the appropriate query mode. Which query mode should you select?

• A. In-Memory with DirectQuery
• B. DirectQuery with In-Memory
• C. In-Memory
• D. DirectQuery

Answer: A

NEW QUESTION 11
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns. What should you do?

• A. In the Properties window for the applicable tables and columns, set the Visible property to True.
• B. Right-click the applicable tables and columns and select the Hide option.
• C. Right-click the applicable tables and columns and select the Hide from Client Tools option.
• D. In the Properties window for the applicable tables and columns, set the Enabled property to False.

Answer: C

NEW QUESTION 12
You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?

• A. Use the Microsoft Azure SQL Database data source type and then set a username and password for the credentials.
• B. Use the SQL Server data source type and then set Windows authentication for the credentials.
• C. Use the Microsoft Azure SQL Database data source type and then set Windows authentication for the credentials.
• D. Use the SQL Server data source type and then set a username and password for the credentials.

Answer: A

NEW QUESTION 13
HOTSPOT
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.

Answer:

Explanation:

NEW QUESTION 14
DRAG DROP
You are developing reports based on the SQL Server Analysis Services (SSAS) cube named ProcessedOrders.
A Multidimensional Expressions (MDX) query must include a query-scoped calculated member, which computes average sales per order item. The query must also return the set of three states in a query-scoped named set named East Coast Customers.
You need to define the calculations in an MDX query to meet the requirements.
Which four MDX segments should you insert in sequence before a SELECT statement? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Answer:

Explanation: Box 1:

Box 2:

Box 3:

Box 4:

Note:
* Example #1: WITH
MEMBER [Measures].[Special Discount] AS [Measures].[Discount Amount] * 1.5 SELECT
[Measures].[Special Discount] on COLUMNS,
NON EMPTY [Product].[Product].MEMBERS ON Rows FROM [Adventure Works]
WHERE [Product].[Category].[Bikes]
* Example 2:
WITH SET [ChardonnayChablis] AS
{[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Good].[Good Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Pearl].[Pearl Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Portsmouth].[Portsmouth Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Top Measure].[Top Measure Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Walrus].[Walrus Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Good].[Good Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Pearl].[Pearl Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Portsmouth].[Portsmouth Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Top Measure].[Top Measure Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Walrus].[Walrus Chablis Wine]}
SELECT
[ChardonnayChablis] ON COLUMNS,
{Measures.[Unit Sales]} ON ROWS FROM Sales

NEW QUESTION 15
DRAG DROP
You need to optimize the Regions dimension.
How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the correct location in the hierarchy relationship. Use only attributes that apply.)

Answer:

Explanation:

NEW QUESTION 16
You have a tabular model hosted in SQL Server Analysis Services (SSAS).
You need to add new rows to an existing table. The solution must load only the new rows to the table.
Which processing mode should you use?

• A. Process Data
• B. Process Full
• C. Process Add
• D. Process Clear
• E. Process Default

Answer: C