多选题You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal？（）AUse the Lock Waits/sec performance counter.BUse the Number of Deadlocks/sec performance counter.CUse the Transactions/sec performance counter.DUse the Full Scans/sec performance counter.EUse the Batches/sec performance counter.

考题 You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.

查看答案

考题 You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.How should you configure the database?A．Configure the database on the two servers as a SQL Server 2000 cluster.B．Configure the database on one server, and then configure a standby database on the second server.C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.D．Configure the database as a federated database, and then partition half the data on each server.

查看答案

考题 You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A．Implement merge replication.B．Implement snapshot replication.C．Implement transactional replication.D．Schedule replication to run continuously.E．Schedule replication to run during off-peak hours.

查看答案

考题 You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.What should you do?A．Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.B．Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.C．Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.D．Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for a financial services company. Replication is configured between two SQL Server 2005 computers， and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator， you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition， you need to make sure that this data is replicated securely. Which action should be performed？（）A、Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.B、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for a standard subscription.C、Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.D、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for an updateable subscription.

查看答案

考题 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 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 a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. A SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect. Which action should be performed？（）A、A stored procedure should be created， and changes are disallowed by the procedure to the Price column that violates company policy.B、On the Price column， a check constraint should be created， and a specified minimum value is required by the check constraint.C、A trigger should be created， and changes are rolled back by the trigger to the Price column that violates company policy.D、On the Price column， a foreign key constraint is created to a table that valid prices are included.

查看答案

考题 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（） A、For the AdventureWorks database, enable Server Auditing B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance C、You should configure the data collector and make it capture the deadlock graphsD、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

查看答案

考题 You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal？（）A、Use the Lock Waits/sec performance counter.B、Use the Number of Deadlocks/sec performance counter.C、Use the Transactions/sec performance counter.D、Use the Full Scans/sec performance counter.E、Use the Batches/sec performance counter.

查看答案

考题 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）A、For the database, you should turn on the TRUSTWORTHY database optionB、For the database, the PAGE_VERIFY database option should be set to CHECKSUMC、For the database, the database compatibility level option should be set to 10D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.

查看答案

考题 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. At present about 90 GB of data is stored in DB1. You made some rough calculations that every day about 1 GB of data is modified or inserted. You set the recovery model of DB1 to Simple. According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable. You have to choose a backup strategy which must comply with the following two requirements: Using as little disk space as possible Complying with the company requirements. So what action should you perform to achieve this goal?（） A、A full database backup should be performed once daily. During business hour, a transaction log backup should be performed every two hours. B、A full database backup should be performed once daily C、A full database backup should be performed once daily. During business hours, a differential backup should be performed every two hours D、Perform a full database backup should be performed once every week. A differential backup should be performed once daily. During business hours a transaction log backup should be performed every two hours.

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.D、You should place a unique index on the PartNum column.

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options， which one is the most possible cause of the problem？（）A、The sp_executesql batches are not being recovered from the procedure cache.B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.C、One new stored procedure is created by a database administrator.D、Ad hoc batches are not being recovered from the procedure cache.

查看答案

考题 You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）A、Schedule the full backups to run after the nightly index is rebuilt.B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.

查看答案

考题 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.C、Configure the RECOVERY INTERVAL option to be a smaller value.D、Run DBCC SHRINKFILE on the transaction log file.

查看答案

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the requirement of the company CIO， users on the SQL Server instance must be able to use the OPENROWSET（） function to query remote data source. In the options below， which sp_configure configuration option should you configure？A、Agent XPs B、remote access C、remote proc trans D、Ad Hoc Distributed Queries

查看答案

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now you get an order from your company CIO， you have to identify whether a database integrity check （DBCC CHECKDB） was run for a particular database. Which log file should you examine？（）A、log.trc B、default.trc C、ERRORLOG D、SQLAGENT

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy， strong passwords are mandated for all domain， local， and application accounts. The company utilizes a Group Policy object （GPO） to deploy the proper domain password policy. MS-DOS-based or UNIX-based operating systems are run by many of the company’s computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator， you are required to confirm that the Services database can be accessed by these computers. And the company’s written security policy should not be violated. Which action should be performed by you？（）A、A domain account should be created for each of the company’s users. And then， each domain account should be offered with access to SQL1 and the Services database.B、A local logon account should be created on SQL1 for each of the company’s users. And then， each logon account should be offered with access to SQL1 and the Services database.C、One SQL Server logon account should be created for all of the company’s computers running MS-DOS or UNIX-based operating systems. And then， the Enforce password policy option should be enabled for users’ accounts. At last， the logon accounts should be provided with access to the Services database.D、A SQL Server logon account should be created for each of the company’s users. And then， the Enforce password policy option should be enabled for each logon account. At last， each logon account should be offered with access to the Services database.E、A virtual directory should be configured through Internet Information Services （IIS） for access to SQL1. And then， users should be directed to the virtual directory for data access.

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）A、To achieve the goal， a Linked Server connection should be configured to the application database.B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.C、To achieve the goal， a Remote Server connection to the application database should be configured.D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.

查看答案

考题 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 professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）A First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.B First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.C First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.D You should place a unique index on the PartNum column.

查看答案

考题单选题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.C 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. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal？（）AUse the Lock Waits/sec performance counter.BUse the Number of Deadlocks/sec performance counter.CUse the Transactions/sec performance counter.DUse the Full Scans/sec performance counter.EUse the Batches/sec performance counter.

查看答案

考题单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）A For the AdventureWorks database, enable Server Auditing B First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance C You should configure the data collector and make it capture the deadlock graphsD You should configure a SQL Profiler trace, and make it capture the deadlock graphs

查看答案

考题单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options， which one is the most possible cause of the problem？（）A The sp_executesql batches are not being recovered from the procedure cache.B A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.C One new stored procedure is created by a database administrator.D Ad hoc batches are not being recovered from the procedure cache.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：