which a combination of products are most likely to sell. You need to configure properties for the DayofMonth c
You are designing a data mining structure for a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The data mining structure must forecast the day of the month on which a combination of products are most likely to sell. You need to configure properties for the DayofMonth column within a data mining solution. What should you do?
Which two actions should you perform?
You are the database administrator of a SQL Server 2005 computer running SQL Server 2005 Enterprise Edition. You support a database named OnlineSales. This database exists on the following three filegroups. The primary filegroupFG1, a read/write filegroup FG2, a read/only filegroup with historical data. The database is set to the Full Recovery model.
You discover that a file from FG1 has been corrupted. FG1 is offline. All other filegroups are online. You need to restore FG1 while minimizing the time when no data is available.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do to manage report subscriptions?
You are a database administrator for AIOTestKing.com. A database named OLTP_Report makes data available to Reporting Services reports. You use Reporting Services to create a report named SalesDeviation, which displays sales goals and sales representatives’ actual sales. You need to manage report subscriptions. All sales representatives located in the Windows Sales group who do not meet sales goals must automatically receive a SalesDeviation report every Monday morning. What should you do?
Which Prediction Query Builder field configuration should you use?
You are designing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The SSAS database includes a data mining model that uses the Microsoft Neural Network algorithm. You use Prediction Query Builder in Microsoft SQL Server Management Studio (SSMS) to build the Data Mining Extensions (DMX) queries for the database. You need to write a query that returns the number of cases in the data mining model and the percentage of the sample cases that fit the model. Which Prediction Query Builder field configuration should you use?
What should you do?
You are an administrator of 12 SQL Server 2005 computers. Users report that one of the SQL Server computers named AIOTestKing F is unavailable for almost an hour starting at 16:00. One of the other SQL Server administrators reports that during this time, he performed a quick routine maintenance task that included a restart. You view the SQL Server logs on AIOTestKing F for the time period in question, as shown in the exhibit.
You need to ensure that this unavailability does not happen again. What should you do?
Which process option should you choose?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You want to change the design of the data mining structure to test different data mining theories. You add columns of the Ordered content type in the data mining model and the underlying case table. You need to ensure that Data Mining Viewer reflects the changes in the data mining structure and the data mining model. Which process option should you choose?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. The master database on AIOTestKing A becomes corrupted. AIOTestKing A contains several SQL Server Agent jobs. All databases are backed up regularly. You rebuild and restore the master database. You need to ensure that AIOTestKing A functions as it did before the database failure. What should you do?
Which parameter of the mining model should you change?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You deploy a data mining structure that includes the Microsoft Clustering mining model. You need to change the properties of the mining model from Scalable K-Means to Non-scalable K-Means. Which parameter of the mining model should you change?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. Every Sunday, AIOTestKing A executes a job that performs a full backup of a database named HR. Each weeknight, AIOTestKing A executes a job that performs differential backups. All jobs have the option enabled to verify data in the backup. The HR database is often not able to be restored after a failure, because of errors with the data stored on the tape. You need to design a restore process that ensures that as much data as possible is restored, even when errors occur. What should you do?
Which option should you use?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
Your data source contains the following tables:
Products table with a column named ProductCategories_ID ProductCategories table with a column named ID The ProductCategories_ID column is used to link to the ID column. You create a data source view with the RetrieveRelationships property set to false.
You need to set the NameMatchingCriteria property of the data source view to an option to create a relationship between the two tables.
Which option should you use?