70-466 Exam
What Does 70-466 practice test Mean?
we provide Approved Microsoft 70-466 simulations which are the best for clearing 70-466 test, and to get certified by Microsoft Implementing Data Models and Reports with Microsoft SQL Server 2012. The 70-466 Questions & Answers covers all the knowledge points of the real 70-466 exam. Crack your Microsoft 70-466 Exam with latest dumps, guaranteed!
Q1. - (Topic 4)
You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment.
The production database has been configured with security roles.
You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server.
Which deployment method should you use?
A. Use the SQL Server Analysis Services Deployment Wizard.
B. Backup and restore the database.
C. Use the SQL Server Analysis Services Migration Wizard.
D. Deploy the project from SQL Server Data Tools to the production server.
Answer: A
Q2. HOTSPOT - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
You create a degenerate dimension.
You need to define a relationship type for the dimension.
Which relationship type should you select? (To answer, configure the appropriate option or
options in the dialog box in the answer area.)
Answer:
Q3. - (Topic 1)
Topic 1, Tailspin Toys
Tailspin Toys is a multinational company that manufactures toys. Tailspin Toys has offices in five regions worldwide. The company sells toys at various retail stores. The company also sells toys directly to consumers through a web site.
The company has the following departments:
...
Sales Distribution Manufacturing
Each department has an office in each region.
The fiscal calendar of Tailspin Toys runs from June to May.
The network contains a server farm that has Microsoft SharePoint Server 2013 installed.
Existing Environment Current Database Environment
Each department uses SharePoint team sites for internal collaboration.
All manufacturing information is stored in a relational database named Manufacturing. All sales information is stored in a relational database named Sales.
Tailspin Toys deploys SQL Server Analysis Services (SSAS) and configures SSAS to use tabular models. SSAS will be used for all sales reports.
Tailspin Toys deploys a SQL Server Reporting Services (SSRS) instance in SharePoint mode.
Sales Database
A database named Sales contains two tables named FactSales and DimProduct. FactSales contains the following columns:
...
SalesID Total Due OrderDate
DimProduct contains the following columns:
....
ProductID ProductName ProductCategory ProductSubcategory
The Sales database contains information about the products. Most of the products have a category and a subcategory. Certain products only have a category.
A sample from DimProduct is shown in the following table.
Requirements
Security Requirements
Tailspin Toys identifies the following security requirement: . Sales department users must be allowed to view the sales transactions from their region only. . Sales department users must be able to view the contents of the manufacturing reports. . Manufacturing department users must be able to create new manufacturing
reports. . Third-party and custom solutions must NOT be deployed to the reporting server. . Sales department users must NOT be able to create new manufacturing reports.
Planned Reporting Implementation
The manufacturing department plans to use the SSRS instance for its reports. The manufacturing department also plans to make its reports accessible from SharePoint. All manufacturing reports will use an existing database named Manufacturing.
Reporting Requirements
Tailspin Toys identifies the following reporting requirements: . All reports must contain the company logo and a header that contains the date and the time that the report was executed. . All reports must be created by using the SQL Server Data Tools.
Manufacturing report
You plan to create a report named Manufacturinglssues.rdl. The report has the following requirements: . Manufacturing department managers must be able to view product issues by product type, manufacturing plant location, and error type. . The manufacturing department managers must be able to change views by choosing options from drop-down lists.
Sales reports
You plan to create a sales report named RegionalSales.rdl. The report has the following requirements: . Users must be able to view the report by using a web browser. By default, subcategories and product details must be hidden when using the browser. . Users must be able to subscribe to receive the report by email. The report must be sent by email as a PDF attachment.
You plan to create a quarterly sales report named QuarterSales.rdl. The report must
display sales data by fiscal quarter.
Technical Requirements
Tailspin Toys identifies the following technical requirements: . Products in the DimProduct table that do NOT have a subcategory must use the category value as the subcategory value. . SSRS must NOT connect to databases more frequently than once every 30 minutes. . Sales department users must be able to use Microsoft Excel to browse tabular data.
=====
You need to recommend a solution for the sales department that meets the security requirements.
What should you recommend?
A. Create one role for all of the sales department users. Add a DAX filter that reads the current user name and retrieves the user's region.
B. Create one role for each region. Configure each role to have read access to a specific region. Add the sales department users to their corresponding role.
C. Create a table for each region. Create a role for each region. Grant each role read access to its corresponding table.
D. Create one role for all of the sales department users. Configure the role to have read access to the sales transactions. Ensure that all of the reports that access the sales transaction data restrict read access to the data from the corresponding sales department region only.
Answer: C
Explanation: Scenario: Tailspin Toys identifies the following security requirement:
.
Sales department users must be allowed to view the sales transactions from their region only.
.
Sales department users must be able to view the contents of the manufacturing reports.
.
Sales department users must NOT be able to create new manufacturing reports.
Q4. - (Topic 4)
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
Q5. - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table.
You need to implement a time dimension.
What should you do?
A. Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
B. Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
C. Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
D. Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.
Answer: A
Q6. DRAG DROP - (Topic 3)
You need to complete the design of the data warehouse.
Which design should you use? (To answer, drag the appropriate tables and relationships to the correct location in the answer area. Use only the tables and relationships that apply.)
Answer:
24. - (Topic 3)
You need to create the sales territory and product measures.
Which aggregate function should you use for both measures?
A. Count
B. COUNT(DIST1NCT column_name)
C. DistinctCount
D. Distinct
Answer: C
Q7. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), 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:
Q8. DRAG DROP - (Topic 4)
You are developing a SQL Server Analysis Services (S5AS) cube. The cube consists of a single measure group.
The measure group consists of one partition that uses MOLAP.
The proactive caching policy has the following requirements:
. The cache must be updated when data is changed in the table named tbIOrders. . Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command.
You need to configure the proactive caching policy to meet the requirements.
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:
Q9. DRAG DROP - (Topic 2)
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:
Q10. - (Topic 4)
...
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
A fact table is related to a dimension table named DimScenario by a column named ScenarioKey.
The dimension table contains three rows for the following scenarios:
Actual
Budget Q1
Budget Q3
You need to create a dimension to allow users to view and compare data by scenario.
What should you do?
A. Use role playing dimensions.
B. Use the Business Intelligence Wizard to define dimension intelligence.
C. Add a measure that uses the Count aggregate function to an existing measure group.
D. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
E. Add a measure group that has one measure that uses the DistinctCount aggregate function.
F. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
G. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
H. Create several dimensions. Add each dimension to the cube.
I. Create a dimension. Then add a cube dimension and link it several times to the measure group.
J. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
K. Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
L. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
M. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
N. Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
O. Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
Answer: L