70-467 Exam
Improve 70-467 test question Guide
Exam Code: 70-467 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-467 Exam.
Q1. You need to select the appropriate mode for the Sales database.
Which mode should you select?
A. ROLAP
B. Direct Query
C. MOLAP
D. In-Memory
Answer: B
Q2. You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the product. For all other products, Projected Revenue is defined as 110 percent of the Total Sales of the product.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
Q3. You need to select the appropriate storage settings for the cube.
Which settings should you choose?
A. Relational OLAP (ROLAP) with proactive caching enabled
B. Multidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of 24 hours
C. Hybrid OLAP (HOLAP) with proactive caching disabled
D. Hybrid OLAP (HOLAP) with proactive caching enabled
Answer: C
Q4. You need to improve the performance of data warehouse queries.
What should you do?
A. Create columnstore indexes.
B. Create clustered indexes.
C. Create indexed views.
D. Create bitmap indexes.
Answer: A
Q5. You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that apply.)
A. Use the Database Synchronization Wizard to upgrade the database to tabular mode.
B. Use SQL Server Integration Services (SSIS) to copy the database design to the SSAS instance, and specify tabular mode as the destination.
C. Use SQL Server Data Tools (SSDT) to redevelop and deploy the projects.
D. Use the current SSAS instance.
E. Install a new instance of SSAS in tabular mode.
Answer: CE
Q6. You need to implement the aggregation designs for the cube. What should you do?
A. Use the CREATE CACHE statement.
B. Use the Aggregation Design Wizard.
C. Create relational indexes on the source tables.
D Use the Usage-Based Optimization Wizard.
Answer: B
Q7. You need to implement security in the cube to limit the sites visible to each user.
What should you do?
A. Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.
B. Create an SSAS server role for each user and assign the sites each user can access to his or her server role.
C. Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
D. Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user.
Answer: C
Q8. You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading.
The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility.
You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use a project deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.
B. Use a package deployment model. Use the Integration Services Deployment Wizard.
C. Use a package deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.
D. Use a project deployment model. Use the Integration Services Deployment Wizard.
Answer: C
Q9. You need to configure package execution logging to meet the requirements. What should you do?
A. Configure logging in each ETL package to log the OnError, Onlnformation, and Diagnostic events.
B. Set the SSIS catalog's Server-wide Default Logging Level property to Performance. C set the SSIS catalog's Server-wide Default Logging Level property to Basic.
C. Set the SSIS catalog's Server-wide Default Logging Level property to Verbose.
D. Configure logging in each ETL package to log the OnError, OnPreExecute, and OnPostExecute events.
Answer: B
Q10. You need to identify the reasons that data alert notifications are not being sent.
Which of the following reasons are possible? (Each correct answer presents a complete solution. Choose al that apply.)
A. The shared schedule is paused.
B. The data source used by the report is disabled.
C. The SSR5 service is not running.
D. The report data has not changed since the previous notification
E. The SQL Server Agent is not running.
F. The SSRS encryption key has been deleted.
Answer: CE