Microsoft 70-466 Exam Sample Questions - Exam4Help
Question No 1
You need to modify the environment before you create the
QuarterSales report. What should you do?
A. Add a date
table to the model that contains columns for the fiscal and calendar quarters.
B. Add a date
table to the model that contains measures for the fiscal and calendar quarters.
C. Configure a
time dimension by using the Time Intelligence Wizard.
D. Configure SSAS
to use a server time dimension.
Answer: C
Question No 2
You need create the data source view for the StandardReports
project. What should you do?
A. Create a data
source, connect it to the data warehouse, and then use the Data Source View
wizard.
B. Generate a
relational schema from the dimensions and cubes by using the Schema Generation
wizard.
C. Create a new
data source view and then use the Import from Table wizard.
D. Execute the
Import from Table wizard and then use the Data Source View wizard.
Answer: A
Question No 3
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
Question No 4
You have a SQL Server Analysis Services (SSAS) database
named DB1 on a server named Server1. You need to deploy DB1 from Server1 to
four other servers. If the destination server already contains a copy of DB1,
the database must be updated only. If the destination server does not contain a
copy of DB1, the database must be copied to the destination server. What is the
best deployment option to use?
More than one answer choice may achieve the goal. Select the
BEST answer.
A. Analysis
Services Deployment Wizard
B. Analysis
Management Objects (AMO) automation
C. Backup and
Restore
D. Synchronize
Database Wizard
Answer: D
Explanation:
In the Synchronize Database Wizard dialog box, type the name
of the source server and source database in the appropriate fields.
Question No 5
You are designing a SQL Server Reporting Services (SSRS)
report to display vineyard names and their year-to-date (YTDJ grape yield.
Grape yield values are classified in three bands:
•High Yield
•Medium Yield
•Low Yield You add a table to the report.
Then you define two columns based on the fields named
VineyardName and YTDGrapeYield You need to set the color of the vineyard text
to red, yellow, or blue, depending on the value of the YTD grape yield values.
What should you do?
A. Use an
expression for The Color property of the vineyard text box.
B. Use an
expression for the TextDecoration property of the vineyard text box.
C. Use an
expression for the Style property of the vineyard text box.
D. Use an
expression for the Font property of the vineyard text box.
E. Add an
indicator to the table.
Answer: A
Question No 6
You are developing a SQL Server Analysis Services (SSAS)
tabular project. In the data warehouse, a table named Employee Security defines
a relationship between a salesperson's name, logon ID, and assigned sales
territory. You need to ensure that each salesperson has access to data from
only the sales territory assigned to that salesperson. You also need to
minimize the development effort. What should you do?
(More than one answer choice may achieve the goal. Select
the BEST answer.)
A. Create a new
role with Read permission and then add each salesperson's logon as a member to
the role.
B. Create a
separate tabular project for each sales territory. Grant each salesperson
access to the corresponding tabular model of the assigned sales territory.
C. Add the
Employee Security table to the model, define the relationships, and then
implement dynamic security by using row filters. Grant each salesperson access
to the model.
D. Create a new
Active Directory Domain Services (AD DS) security group and add each salesperson
as a member. Then create a new role with Read permission. Add the group as a
member to the new role.
Answer: C
For More Info Visit Us: Exam4Help
