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?
which context should the SQL Server service run?
You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2005. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company’s written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges. You need to configure the SQL Server service to run under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?
Which data mining model should you modify?
You are analyzing a data mining structure that is hosted on a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You view the classification matrix for a data mining structure as shown in the following exhibit. (Click the Exhibit button.) You need to modify the parameters of the data mining model that has the largest percentage of inaccurate predictions. Which data mining model should you modify?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night, a full backup is made of the database, and all database indexes are rebuilt. The company’s network administrator reports that AIOTestKing As network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for AIOTestKing A.
What should you do?
What should you do?
You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You have deployed a Microsoft SQL Server 2005 Analysis Services (SSAS) based data source named PhoneMetrics that accesses the PhoneMetrics cube. You need to permit clients to create ad hoc reports from the Web. What should you do?
What should you do?
You are the database administrator for AIOTestKing.com. You create a new stored procedure.
You run the stored procedure and discover an error. You want to gather and process any error information that is generated while running the procedure. Error logging must use the minimal amount of resources while providing the needed functionality. You need to know what caused the error. You also need to include the appropriate error functions in the new stored procedure. What should you do?
What should you do?
You are administering a Microsoft SQL Server 2005 Reporting Services (SSRS) solution. SSRS is installed on 10 Web servers in a Network Load Balancing configuration. When the SSRS service starts, only the first Web server makes connections to the Report Server database. You need to connect additional Web servers in the SSRS Web farm. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. Your company uses merge replication to replicate data between SQL Server 2005 computers. Users sometimes report that data on some of the computers is out of date. When this happens, you discover that merge replication times out before the merge could complete. You need to ensure that you are automatically notified by SQL Server when this problem occurs. What should you do?
What should you do?
You are creating a Microsoft SQL Server 2005 Reporting Services (SSRS) report. You deploy a new report by using Business Intelligence Development Studio (BIDS) from a test environment. Previously deployed reports display errors indicating unavailable production servers. You need to modify the SSRS project by using BIDS to allow the previously deployed data sources to work properly. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. A new SQL Server 2005 computer named AIOTestKing B hosts a mission-critical customer relationship management (CRM) database. All of the companys 500 employees in the sales and marketing departments access the CRM database. Your department has an annual budget for the purchase of new hardware and software. You need to devise a monitoring strategy that enables you to make decisions about the history of server performance. The monitoring strategy should also advise you on how to best allocate funds for hardware upgrades. What should you do?