What should you do?
You are designing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a dimension named DimProducts that contains the following features:
An attribute named Categories.
A key attribute named Products that has a relationship to the Categories attribute.
A hierarchy that has the Categories attribute on the first level and the Products attribute on the second level.
When you browse through the dimension, it shows all the Products that do not have a relationship to the Categories attribute. The attribute is grouped under a Categories member named Unknown.
You need to ensure that only those products that have a relationship to the Categories attribute are displayed.
What should you do?
What should you do first?
You are the database administrator for AIOTestKing.com. You manage a SQL Server 2005 database named Sales. You are given a SQL Server Profiler sample workload with queries to the Sales database on a typical day. You need to evaluate the effectiveness of current indexing and identify changes that would be appropriate. What should you do first?
Which of the predefined ProactiveCaching values property should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The cube must store details of the data in a relational format and the aggregations in a multidimensional format.
Which of the predefined ProactiveCaching values property should you use?
What should you do?
You are a database administrator for AIOTestKing.com. The company’s manufacturing floor has three automated testing areas for finished items. Each testing area uses SQL Server 2005 to store test results. You need to develop a replication strategy to ensure that test results flow continuously from the testing areas to the central SQL Server as quickly as possible. The test results are used for reporting. What should you do?
What should you do?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
Your data source view has a table named Products. The Products table contains the following three columns:
ProductKeyCostDiscount
The table also contains a named calculation column named PercentageCost.
You need to add another column named DiscountedCost that will display the value of Cost*Discount/100.
What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. You are creating a new SQL Server Integration Services (SSIS) package. The package will import one or more text files into a database each night. These text files are provided by company vendors and are not related to one another. You need to ensure that the package always succeeds, even if no text files are provided, with the least amount of administrative effort. What should you do?
What should you do?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. A database named CallCenterMetrics contains a data mining structure named Call Center Forecasting. The data mining structure implements the Microsoft Neural Network mining model and the Microsoft Clustering- based mining model. You need to change the parameters for both the mining models to narrow the number of rows that are returned from Microsoft Mining Content Viewer. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. Users report that a SQL Server 2005 application stops responding for several seconds at a time during the day. This problem occurs randomly throughout the day and affects many users at once. When the problem occurs, you notice that CPU utilization and disk utilization on the SQL Server 2005 computer are low, but that the network is operating normally. You need to examine additional information relevant to the problem. What should you do?
What should you do?
You are designing a data mining structure for a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The solution requires the use of relational data. You need to design the data mining structure so that the data mining models can use the data from a case table and a nested table. What should you do?
What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. You are creating a SQL Server 2005 database that will contain many tables to store contact information for customers, partners, and vendors. You need to ensure consistency in the data types that are used in all columns in the database tables. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)