What should you do?
You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 computer that runs Reporting Services. The server runs reports that include only data from the previous days sales. You discover that an OLTP database application runs slowly when reports are run during business hours and that reports sometimes time out.
You need to correct the problem and prevent it from recurring. What should you do?
What should you do?
You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a cube in an SSAS instance. You notice that the queries run slowly. You need to identify the queries that run slowly and change the storage configuration of the cube. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. You manage 10 SQL Server 2005 computers. The computers reside on an isolated portion of the company’s network that has been restricted from accessing the Internet. Only intranet client computers have access to the SQL Server 2005 computers. You need to audit the SQL Server computers to identify only the missing operating system or SQL Server patches, hotfixes, and service packs. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is connected to a database on your development server by using a connection manager. You decide to use the DTExecUI utility to run the package. You need to change the connection of the connection manager to a different server at run time without using a package configuration file. What should you do?
What should you do?
You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 stores confidential customer information in a database named Customers. The company’s written security policy states that transmission of customer data between client computers and servers must always take place in a manner that supports authentication, non-repudiation, and encryption. Client computers that do not support the company’s written security policy are denied data access. You need to ensure that the Customers database is in compliance with the company’s security policy. What should you do?
What should you do?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a dimension that contains a parent-child hierarchy. The dimension has a key attribute named Employee and a parent attribute named Employees. You need to ensure that the dimension identifies the topmost employee member of the hierarchy as the root member. What should you do?
What should you do first?
You are the administrator of a SQL Server 2005 computer named SQL1. Users report that SQL1 is not responsive. You discover that SQL1s network segment is heavily utilized. You cannot connect to SQL1 by using the graphical SQL Server administrative tools. You suspect that SQL1 is the target of a Denial of Service (DoS) attack. You need to connect to SQL1 to examine the current activities. What should you do first?
What should you do?
You need to create a package that must meet the following requirements:
It must be transactional. It must be optimized for 20 tables. It must be stored securely in the msdb database of a remote server.
What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. Your company uses a SQL Server 2005 application. The application executes a query that returns three columns of the nvarchar data type and one column of the XML data type. The query uses a WHERE clause that includes all three of the nvarchar columns. The table contains 5 million rows, and the query returns 50,000 rows. You need to improve the performance of the query.
What should you do?
What should you do?
Your server hosts Microsoft SQL Server 2000 Analysis Services (SSAS) databases and cubes. You need to perform the migration of a database from Analysis Services 2000 to Analysis Services 2005. What should you do?