默认题库 - MCITP(70-444)

单选题

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

A. Configure a Linked Server connection to the application database.
B. Write a query that uses an OPENDATASOURCE command.
C. Write a query that uses an OPENQUERY command.
D. Configure a Remote Server connection to the application database.

查看答案

单选题

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 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 SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）

A. Configure the database to use the bulk-logged recovery model.
B. Each night， rebuild only those indexes that require it.
C. Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
D. Increase the time between transaction log backups.

查看答案

单选题

You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）

A. Decrease the amount of time between transaction log backups.
B. Configure the database to use the simple recovery model.
Configure the RECOVERY INTERVAL option to be a smaller value.
D. Run DBCC SHRINKFILE on the transaction log file.

查看答案

单选题

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）

A. DBCC DBREINDEX
B. SELECT * FROM sys.dm_db_index_physical_stats
C. DBCC INDEXDEFRAG
D. SELECT * FROM sys.indexe

查看答案

单选题

You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do？（）

A. Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
B. Query the sys.server_permissions table on Server1.
C. Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
D. Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

查看答案

单选题

You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory， but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources. What should you do？（）

A. Design a report for Susan that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then， design a report for Joe that displays the detailed sales data.
B. Design two reports for Susan. One report includes the territory information， and one report includes the detailed sales data. Then， design a report for Joe that displays the detailed sales data for his territories.
C. Design a report for Susan that includes the territory information. Then， design a report for Joe that includes detailed sales data for his territories. Finally， configure Susans report so that it includes the data in Joes report.
Design a parameterized report for Susan that includes all territory information. Then， design a linked report for Joe that links to Susans report.

查看答案

单选题

You are a database administrator for your company. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do？（）

A. Decrease the time between transaction log backups of the database.
B. Delete report snapshot history each week.
C. Minimize the use of session caching in the reports.
D. Minimize the use of report snapshots in the reports.

查看答案

单选题

You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）

A. Use the DBCC INPUTBUFFER command.
B. Use the sys.dm_exec_query_stats dynamic management view （DMV）.
C. Use the sqldiag utility.
D. Use the SHOWPLAN session option.

查看答案

单选题

You are the administrator of a SQL Server 2005 computer named SQL1. All servers run Microsoft Windows Server 2003 and belong to a Microsoft Active Directory domain. The companys written security policy mandates strong passwords for all domain， local， and application accounts. The appropriate domain password policy has been deployed through the use of a Group Policy object （GPO）. Many of the company’s computers run MS-DOS-based or UNIX-based operating systems. These computers require varying levels of access to a database named Services on SQL1. You need to ensure that these computers can access the Services database without violating the company’s written security policy. What should you do？（）

A. Create a domain account for each of the company’s users. Provide each domain account with access to SQL1 and the Services database.
B. Create a local logon account on SQL1 for each of the company’s users. Provide each logon account with access to SQL1 and the Services database.
Create a SQL Server logon account for each of the company’s users. Enable the Enforce password policy option for each logon account. Provide each logon account with access to the Services database.
D. Configure a virtual directory through Internet Information Services （IIS） for access to SQL1. Direct users to the virtual directory for data access.
E. Create one SQL Server logon account for all of the company’s computers running MS-DOS or UNIX-based operating systems. Enable the Enforce password policy option for users’ accounts. Provide the logon accounts with access to the Services database.

查看答案

单选题

You are the administrator of a SQL Server 2005 computer named SQL1. You create a security template that disables unnecessary services. The template is appropriate only for SQL1. You need to ensure that the security template is applied to SQL1. Your solution must ensure that the template automatically overrides any manual configuration changes made by other administrators within an hour. What should you do？（）

A. Use the SQL Server Surface Area Configuration tool to import the security template.
B. Use the Local Security Policy editor to import the security template into the Local Security Policy object.
Configure Task Scheduler to import the security template by using Secedit.exe. Configure the task to run every half hour.
D. Configure Task Scheduler to run the Microsoft Baseline Security Analyzer tool every half hour.

查看答案