(
70-446)
PRO:Design a Business Intellig Infrastr Usi MS SQL Serv 2005Microsoft 70-446 Exam - Certifysky.com
Free 70-446 Sample Questions:
1. BACKGROUND Fabrikam,Inc,is a manufacturing company that provides components for the engineering industry, fabrikam has a sister company named contoso,Ltd, Work order are processed by the folloeing departments: The Production department handles request for components that are not in stock, The Warehouse department handles the storage and stock management of premanufactured componets. The Warehouse department handles the packaging of stock in the warehouse or the production department. The Distribution department handles the delivery of orders to clients. The company uses a flexble resourcing structure where individual employees can be reassiqned between department. Productivity is higher when specific groups of staff members are assigned to a particular department. EXISTING ENVIRONMENT Fabrikam uses a Micrisoft SQL Server 2005 database named FabrikamSQLDB to control and route client requests as work order to the respective department. New Client and Product Order records can be added to the FabrilamSQLDB database throughout the day ,these records must be reflected correctly in any reports with zero latency. The FabrikamSQLDB schema is shown in the following exhibit.(Click the Case Study Exhibits button to view the FabrikamSQLDB schema.)
2.You need to ensure the Client dimension is able to support new orders and new client records. Which setting should you configure?
A. ROLAP storage
B. Lazy aggregations
C. Write Enabled property
D. Unknown Member functionality
Answer: A
3.You need to meet the requirements of the accounts team. What should you do?
A. Set the Dimension type to Currency.
B. Set the Currency member name as a unique attribute.
C. Hide nonleaf data within the Currency dimension key attribute.
D. Disable the All member of the Currency dimension key attribute.
Answer: D
4. You need to make structural changes to the cube. You also need to ensure that appropriate aggregations are created after the changes are made. What should you do?
A. Record a weeks user activity by using SQL Profiler. Apply structural changes. Replay the activity and then run the Usage Based Optimization Wizard.
B. Apply structural changes. Run the Database Engine Tuning Advisor.
C. Apply structural changes. Run the Usage Based Optimization Wizard.
D. Record a weeks user activity by using SQL Profiler. Apply structural changes. Run the Database Engine Tuning Advisor.
Answer: A
5. You need to select appropriate processing methods for the EmployeeAssignment measure group and the Employee dimension. Which method should you choose?
A. Run a Process Update against the Employee dimension. Run a Process Full against the EmployeeAssignment measure group.
B. Run a Process Full against the EmployeeAssignment measure group. Run a Process Update against the Employee dimension.
C. Run a Process Full against the Employee dimension. Run a Process Incremental against the
EmployeeAssignment measure group.
D. Run a Process Incremental against the EmployeeAssignment measure group. Run a Process Full against the Employee dimension.
Answer: A
6. You need to ensure that the new sales manager is able to view clients within only the North and South regions. What should you do?
A. Add a Denied member set for the West clients to NorthRole.
B. Add an Allowed member set for the South clients to NorthRole.
C. Create a new role for the sales manager and add a Denied member set for the South clients.
D. Create a new role for the sales manager and add an Allowed member set for the South clients. Remove the sales manager from SouthAndWestRole.
Answer: D
7. You need to meet the business requirements of the packaging department. What should you do?
A. Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Set the order of the ProductSKU attribute to the ProductSizeDescriptor column.
B. Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Set the order of the key attribute of the ProductSize dimension to the ProductSizeDescriptor column.
C. Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Create a userdefined hierarchy that has ProductSKU as the toplevel attribute and ProductSizeDescriptor as the bottomlevel attribute.
D. Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Create a userdefined hierarchy within the ProductSize dimension. Set the ProductSizeDescriptor attribute as the toplevel attribute.
Answer: A
8. You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?
A. Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.
B. Create a Server Time dimension. Within this dimension, enable the time periods year, month, and date. Select the Additional Manufacturing calendar option.
C. Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.
D. Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.
Answer: D
9. You need to design a storage mode for the ProductOrderStatus measure group. What should you do?
A. Use ROLAP for the Historical partition and MOLAP for the CurrentDay partition.
B. Use MOLAP for the Historical partition and ROLAP for the CurrentDay partition.
C. Use ROLAP for the Historical partition and Automatic MOLAP for the CurrentDay partition.
D. Use HOLAP for the Historical partition and Lowlatency MOLAP for the CurrentDay partition.
Answer: B
10. You need to maintain the partitions on the ProductOrderStatus measure group. What should you do?
A. Create a Microsoft SQL Server 2005 Integration Services (SSIS) package that alters the partition queries and processes aggregated partitions every evening.
B. Enable proactive caching on the partitions. Set the cache to update periodically with a latency of 24 hours.
C. Set the rebuild interval of the partitions to 36 hours. Create a Microsoft SQL Server 2005 Integration Services (SSIS) package that processes aggregated partitions every evening.
D. Enable proactive caching on the ProductOrderStatus measure group. Set scheduled polling that reprocesses the measure group whenever the system dates change.
Answer: A
11. BACKGROUN Woodgrove Bank is a banking institution that offers deposit accounts and mortgage accounts. At present, the bank holds 1,000,000 accounts. On an average 50,000 new accounts are added every year. Ten percent of the accounts are mortgage accounts. The balances
of mortgage accounts are recalculated every week. Some of the existing Microsoft SQL Server Reporting Services(SSRS) Reports are doublecounting transactions where there is more than one account holder for the same account. EXISTING ENVIRONMENT Woodgrove Bank has partially implemented a data warehouse named WoodgrovDW. WoodgrovDW Data Store The WoodgrovDW database schema is shown in the exhibit. (Click the Case Study Exhibits button to view the WoodgrovDW Data Store schema.)
12.You need to reduce the duration of the daily full database backup process. What should you do?
A. Perform transaction log backups every 30 minutes throughout the day.
B. Partition the Transaction table by a range based on the TransactionID. Daily, back up only the file groups that have changed.
C. Place the Transaction table in its own file group. Back up the Transaction table and the remaining file groups each evening.
D. Partition the Transaction table by a range based on the MortgageID. Daily, back up only the file groups that have changed.
Answer: B
13. You need to identify the data mining algorithm that meets the requirements of the credit department. Which algorithm should you use?
A. Microsoft Clustering
B. Microsoft Decision Tree
C. Microsoft Nave Bayes
D. Microsoft Association
Answer: B
14. You need to deliver the three reports that detail the previous days transaction activity. What should you do?
A. Create a new report that has three embedded subreports. Create one standard subscription.
B. Create three new reports based on the same dataset. Create one datadriven subscription.
C. Create three datadriven subscriptions on a single shared schedule. Ensure that the email recipient list
is identical across all three subscriptions.
D. Create three standard subscriptions on a single shared schedule. Ensure that the mail recipient list and subject are identical across all three subscriptions.
Answer: A
15. You need to meet the fraud detection requirements. What should you do?
A. Use Percentage Sampling in SSIS.
B. Use a Neural Network Data mining algorithm.
C. Create an SSAS Key Performance Indicator for each account.
D. Monitor transactions by using SQL Server Profiler.
Answer: B
16. You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?
A. Custom event handlers
B. Data flow error output
C. SSIS log provider for SQL Server
D. Execute SQL tasks with failure precedence constraints
Answer: A
17. You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?
A. Replace the named query with an SQL view.
B. Set the transaction isolation level to serializable in the named query.
C. Set the source database to use snapshot isolation.
D. Set the transaction isolation level to repeatable read in the named query.
Answer: C
18. You need to resolve the double counting of transactions issue in the existing reports. What should you do?
A. Apply a manytomany relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.
B. Apply a Conditional Split transformation in the Transaction data in the SSIS package.
C. Delete the AccountHolder table in the WoodgroveDW database.
D. Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.
Answer: A
19. You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?
A. Microsoft SQL Server 2005 Mobile Edition
B. Microsoft SQL Server 2005 Express Edition
C. Microsoft SQL Server 2005 Standard Edition
D. Microsoft SQL Server 2005 Workgroup Edition
Answer: B
20. BACKGROUND Fourth Coffee is a chain of coffee shops that operates in North America. Service personnel in the outlets receive commission for each item they sell. The outlets are grouped into geographical reg. EXISTING ENVIRONMENT Fourth Coffee Database Schema The Fourth Coffee database schema is shown in the following exhibit. (Click the Case Study Exhibits button to view the Fourth Coffee database schema.)
21. You need to ensure that the TownStore hierarchical structure is displayed accurately in reports. How should you modify the Store dimension?
A. Add Town as an attribute relationship to StoreID in the SSAS solution.
B. Modify the StoreName attribute and set the MemberNameUnique property to true.
C. Add the StoreID attribute to the bottom of the TownStore hierarchy in the SSAS solution.
D. Use column binding to add Town to the Key column of the StoreName attribute in the SSAS solution.
Answer: D
22. You need to ensure the marketing department is able to implement crossselling requirements. Which data mining model should you choose?
A. Microsoft Time Series
B. Microsoft Nave Bayes
C. Microsoft Neural Networks
D. Microsoft Association
Answer: D
23. You need to ensure the PointOfSales system supports crossselling functionality. What should you do?
A. Use ADO.NET to execute a TransactSQL statement to retrieve the data.
B. Use ADOMD.NET to execute a Data Mining Extensions (DMX) query to retrieve the data.
C. Use ADOMD.NET to execute a Multidimensional Expressions (MDX) query to retrieve the data.
D. Use Microsoft SQL Server 2005 Integration Services (SSIS) package that runs overnight to execute a data mining query task.
Answer: B
24. You need to calculate the average quantity of products sold by each store. What should you do?
A. Create a calculated member within the Measures hierarchy. Divide the Quantity measure by a distinct count of store members.
B. Create a calculated member within the StoreID hierarchy of the Store dimension. Divide the Quantity measure by a distinct count of store members.
C. Create a calculated field within the SaleQuery table inside the data source view. Divide the QuantitySold column by a distinct count of the number of stores.
D. Create a calculated field within the Store data table inside the data source view. Sum the QuantitySold column by that store and divide by the number of
sales made.
Answer: A
25. You need to include the attributes of the Region dimension within the SSRS report. What should you do?
A. Join the Region dimension to the Sales measure group by using a Fact relationship type.
B. Join the Region dimension to the Sales measure group by using a Regular relationship type.
C. Join the Region dimension to the Sales measure group by using a Referenced relationship type.
D. Join the Region dimension to the Sales measure group by using a ManytoMany relationship type.
Answer: C
26. You need to implement the security requirements of the SupplierData report. What should you do?
A. Use the Internet Information Services (IIS) security to prohibit access to the new report.
B. Within Report Manager, grant Browser rights and Report Builder rights on the new sales report to the users of the management group.
C. Create a new user group and add all management users to this group. Within Report Manager, grant Browser rights on the report to the management group.
D. Create a new user group and add all management users to this group. Use the file system security to grant access to the report for the management group.
Answer: C
27. You need to alter the StaffMember dimension and measure group relationship to resolve the processing errors. You also need to meet the
requirements for handling NULL values in the StaffMember dimension. What should you do?
A. Alter the relationship to map NULL to zero or blank. Add a default member to the StaffMember dimension.
B. Alter the relationship to map NULL to Unknown. Design the Unknown Member functionality within the dimension.
C. Alter the relationship to error upon NULL key values. Design the custom error configuration in the StaffMember dimension.
D. Alter the relationship to preserve NULL values. Design the Missing Member Mode functionality of Multidimensional Expressions (MDX) in the dimension.
Answer: B
28. You need to design the Monthly Sales Items report for the regional managers. What should you do?
A. Create a single report that uses the caching functionality of SSRS.
B. Create a single report in SSRS by using a Matrix format that has the lower levels of grouping collapsed by default.
C. Create a single parent report that displays the highest level of aggregate data. Embed subreports for each grouping of child data.
D. Create a summary report. Add drillthrough functionality to the summary report to link to separate detailed reports for each grouping of data.
Answer: D
29. You need to ensure that all blank rows in the PivotTable reports are hidden. Which property of the Product dimension should you set?
A. Set the AttributeHierarchyEnabled property to false.
B. Set the HideMemberIf property to NoName.
C. Set the AttributeHierarchyVisible property to true.
D. Set the AttributeHierarchyVisible property to false.
Answer: B
30. You need to create a data mining model to support the SalesProjections report. How should you modify the SSAS solution?
A. Create a mining model on the existing Time Of Day dimension by using the Microsoft Time Series algorithm.
B. Create a Date dimension within the SSAS solution. Use the new Date dimension within a Microsoft
Time Series data mining model.
C. Create a Key Performance Indicator (KPI) that displays sales trends.
D. Create a data mining model on the existing Store dimension by using the Microsoft Time Series algorithm.
Answer: B
More Free Microsoft 070-446 exam questions
70-446 Exam Prep
Learn what you need to know to pass the 70-446 exam easily
Guarantee your 70-446 success with our 70-446 Exam Resources. Our exams are developed by experiences IT Professionals working in today's prospering companies and date centers. All our practice exams including 70-446 exam guarantee you the exam success you need.
CertifySky offers free demo for 70-446 exam. You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products. If you want to try 70-446 Exam Prep Demo, Click the "Try Demo" button.
0-446 Certification Exam and Study Guide
There are many online resources for preparing for the 70-446 exam. Read below to discover why Certifysky.com is your premier source for practice tests, and true testing environment.
CertifySky is the online Certification Expert recognized by a worldwide audience of IT professionals and executives alike as the definitive source of training materials for the candidate seeking insight, updates and resources for vendor certifications.
70-446 Practice Test Questions, Printable PDF Braindumps
We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our 70-446 Preparation Exam Material provides you everything you will need to take a certification examination. Details are researched and produced by Certification Experts who are constantly using industry experience to produce precise, logical and verified explanations for the answers. You may get questions from different web sites or books, but logic is the key.
Comprehensive questions with complete details
Questions accompanied by exhibits (when applicable)
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams (when applicable)
Questions updated on regular basis
These questions and answers are backed by our GUARANTEE
Like actual certification exams our product is in multiple-choice questions (MCQs) |
Our
70-446 Exam will provide you with exam questions and verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. Our 70-446 Exam is not just questions and answers. They are your access to high technical expertise and accelerated learning capacity. Certification Experts, Certified Computer Trainers, Technical Coworker and Comprehensive Language Masters, who have a solid, verified and certified background and high technical expertise, have compiled these detailed questions and answers.
70-446 Certification preparation Q and A provided by
Certifysky.com will make you feel like you are taking an actual exam at a Prometric or VUE center.
Furthermore, we are constantly updating our
70-446 Exam. These 70-446 Exam updates are supplied free of charge to Certify Sky.com customers- hereby becoming an investment rather than a disposable product. Our clients receive the most reliable and up-to-date information when they decide to take the exam, just contact us. Our candidates walk into the Testing Room as confident as a Certification Administrator.
Like actual certification exams our 70-446 Exam is in multiple-choice questions (MCQs). After purchasing our products you are just a step away from testing for certification. Still not convinced? Try our free samples or choose to buy your
70-446 Practice Exam now!
Our 70-446 practice exams and study questions are composed by current and active Information Technology experts, who use their experience in preparing you for your future in IT.
Commitment to Your Success: At Certifysky.com we are committed to you ongoing success. Our exams and questions are constantly being updated and compared to industry standards.
You are not about to purchase a disposable product.
70-446 practice exam updates are supplied free of charge. Regardless of how soon you decide to take the actual
70-446 examination certification, you will be able to walk into the testing room as confident as the Certification Administrator.
The CertifySky
70-446 study guide is guaranteed to be 100% braindump free. We value the quality of training you receive through the 70-446 study guide and will never support 70-446 braindumps, or any 70-446 brain dump site.
70-446 braindump sites cannot compare to the understanding, learning and comprehension you will gain from a non-
70-446 braindumps site, based on facts and case studies, like Certify Sky.
When selecting the CertifySky 70-446 exam study preparation materials, you are purchasing the highest quality CertifySky 70-446 products available through the web today. The 70-446 CertifySky practice exams and study guides are current and updated monthly, providing you with the highest 70-446 Certify Sky ROI. Start you road to 70-446 CertifySky success today, buy purchasing the CertifySky 70-446 training materials today!
Comprehensive questions with complete details
