Vendor
: Microsoft
Exam Code : 70-467
Version: Demo
Cheat-Test, help you pass any IT exam!
Cheat-Test.com - The Worldwide Renowned IT Certification Material Provider! The safer, easier way to help you pass any IT Certification exams.
We provide high quality IT Certification exams practice questions and answers (Q&A). Especially Cisco, Microsoft, HP, IBM, Oracle, CompTIA, Adobe, Apple, Citrix, EMC, Isaca, Avaya, SAP and so on. And help you pass an IT Certification exams at the first try.
Cheat-Test product Features: •
Verified Answers Researched by Industry Experts
•
Questions updated on regular basis
•
Like actual certification exams our product is in multiple-choice questions (MCQs).
•
Our questions and answers are backed by our GUARANTEE.
7x24 online customer service: contact@cheat-test.com
Click Here to get more Free Cheat-Test Certification exams!
http://www.Cheat-Test.com
Q: 1 You work as a Database Administrator (DBA) at a company named ABC.com. The corporate network includes a SQL Server 2012 infrastructure. The company has a large data warehouse named CorpDW. New data is added to a fact table named CurrentInfo in the data warehouse throughout the day. A server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). You have an SSAS cube named ABC-Cube1 which contains a measure group supported by the CurrentInfo fact table. You need to configure the partitioning for the cube to optimize query performance across all aggregation levels whilst ensuring the cube is available as much as possible and displays the most up-to-date data as quickly as possible. You plan to create a single partition to host the current day’s data. How should you configure the partition? A. Select HOLAP (Hybrid OLAP) as the storage mode. B. Select ROLAP (Relational OLAP) as the storage mode. C. Select MOLAP (Multidimensional OLAP) as the storage mode and schedule the partition processing to run every night. D. Select MOLAP (Multidimensional OLAP) as the storage mode and select the proactive caching mode. Answer: D Q: 2 You work as a Database Administrator (DBA) at a company named ABC.com. The corporate network includes a SQL Server 2012 infrastructure. A server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). The company has a large data warehouse named CorpDW. You need to create an SSAS cube to query CorpDW. The cube will use the multidimensional OLAP (MOLAP) storage mode. You need to recommend a solution that will automate the collection of aggregation tuning workloads. Any manual tuning of aggregations must minimize the performance impact of queries that have already been tuned and the effort required must be minimized. Which of the following steps should you include in your solution? A. Set up multiple partitions. B. Generate aggregations using the Usage-Based Optimization Wizard. C. Enable query logging in SSAS. D. Run the Aggregation Design Wizard on each partition. E. Replace the current aggregation design with the results of the wizard. F. Merge the results of the wizard with the current aggregation design. Answer: B,C,F Q: 3 You work as a Database Administrator (DBA) at a company named ABC.com. The company has a SQL Server 2012 infrastructure. You have a database named CorpDB1. You need to create a fact table in CorpDB1 that will expand to contain billions of rows. You need to design the most efficient table to maximize the performance of queries. Users must be able to choose up to 12 dimension tables and up to a maximum of 4 facts for any query. Measures will be aggregated by the queries by using any of the 12 dimensions. You need to include a columnstore index for the table. Which three of the following configurations would best meet these requirements? (Choose three)
A. Configure 12 dimensional key columns in the fact table. B. Configure 4 measure columns in the fact table. C. Configure 4 dimensional key columns in the fact table. D. Configure 12 measure columns in the fact table. E. Use only the dimensional key columns for the columnstore index. F. Use only the measure columns for the columnstore index. G. Use the dimensional key columns and the measure columns for the columnstore index. Answer: A,B,G Q: 4 You work as a Database Administrator (DBA) at a company named ABC.com. The corporate network includes a SQL Server 2012 infrastructure. A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration Services (SSIS). You need to determine which package configuration to use for SSIS packages. You need to select a package configuration option that will allow you to store multiple configuration properties/values and ensure that all the properties/values are loaded. Which of the five package configuration options should you use? A. XML Configuration File B. Environment Variable C. Registry Entry D. Parent Package Variable E. SQL Server Answer: A Q: 5 You work as a Database Administrator (DBA) at a company named ABC.com. The corporate network includes a SQL Server 2012 infrastructure. A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration Services (SSIS). You need to determine which package configuration to use for SSIS packages. You need to select a package configuration option that will allow you to store multiple configuration properties/values and support encryption using EFS (Encrypted File System). Which of the five package configuration options should you use? A. XML Configuration File B. Environment Variable C. Registry Entry D. Parent Package Variable E. SQL Server Answer: A