网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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. 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 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 work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
考题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup
考题
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 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 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 have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases. What should you include in your naming convention（）？ A、For each mailbox database， provide a database name that is unique within the organization.B、For each mailbox database， provide a database name that is unique within the Mailbox server.C、For each mailbox database file， provide a file name that is unique within the organization.D、For each mailbox database file， provide a file name that is unique within the Mailbox server.
考题
You need to define an authentication system for the main office database administrators. The setup should require the minimum amount of administrative effort. The authentication environment must fulfill the company’s security requirements.What should you do？（）A、Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.B、Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.C、Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.D、Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.
考题
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company. SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application developers. A fixed cache file is required by one of the packages. The company will deploy the packages to the production server on completion of development. The production server is available only to the database administrators. Since you are the technical support, you need to confirm that the project can be deployed successfully to the production server by the application developers. Which action will you perform to achieve the goal?（）A、To achieve the goal, the Import and Export Wizard should be utilized to save packages.B、To achieve the goal, a direct package configuration should be created for each package.C、To achieve the goal, a deployment utility should be created for the SSIS project. D、To achieve the goal, an indirect package configuration should be created for all packages.
考题
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.
考题
Your company has four regional offices. You install the Windows Deployment Services （WDS） role on the network. Your company creates three images for each office. There are a total of 12 images for the company. The images will be used as standard images for workstations. You deploy the images by using WDS. You need to ensure that each administrator can view only the images for his or her regional office. What should you do？（）A、Create a global group for each regional office and place the computers in the appropriate global group.B、Create an organizational unit （OU） for each regional office and place the computers in the appropriate OU.C、Place all images into a single image group on the WDS server. Grant each administrator permissions to the image group.D、Place each regional office into a separate image group on the WDS server. Grant each administrator permissions to his or her regional offices image group.
考题
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. 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 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 as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A
Database ControlB
Management ServerC
Management RepositoryD
Application Server ControlE
Oracle Management Agent
考题
单选题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 as a database administrator for your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）A
To achieve the goal， DBCC DBREINDEX should be utilized.B
To achieve the goal， SELECT * FROM sys.indexes should be utilized.C
To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.D
To achieve the goal， DBCC INDEXDEFRAG should be utilized.
考题
单选题You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A
Information about each Oracle Net connection.B
Information about each entry in theLinstener.orafileC
Information about the changed done in the databaseD
Information about the different listeners in your systemE
Information about all thenondatabasefiles required to operate the database
考题
单选题You are the administrator of your company’s network. Using Windows Installer packages， you want to install customized versions of Microsoft Excel on different departments in the company. Which type of file should you apply to the installation database？（）A
msiB
mstC
zapD
zip
考题
单选题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 the network administrator for your company. The network consists of a single Active Directory forest. The forest consists of 19 Active Directory domains. Fifteen of the domains contain Windows Server 2003 domain controllers. The functional level of all the domains is Windows 2000 native. The network also consists of a single Microsoft Exchange 2000 Server organization. You need to create groups that can be used only to send e-mail messages to user accounts throughout the company. You want to achieve this goal by using the minimum amount of replication traffic and minimizing the size of the Active Directory database. You need to create a plan for creating e-mail groups for your company. What should you do？（）A
Create global distribution groups in each domain. Make the appropriate users from each domain members of the global distribution group in the same domain. Create universal distribution groups. Make the global distribution groups in each domain members of the universal distribution groups.B
Create global security groups in each domain. Make the appropriate users from each domain members of the security group in the same domain. Create universal security groups. Make the global security groups in each domain members of the universal security groups.C
Create universal distribution groups. Make the appropriate users from each domain members of a universal distribution group.D
Create universal security groups. Make the appropriate users from each domain members of a universal security group.
考题
单选题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 DBREINDEXB
SELECT * FROM sys.dm_db_index_physical_statsC
DBCC INDEXDEFRAGD
SELECT * FROM sys.indexes
考题
单选题You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases. What should you include in your naming convention（）？A
For each mailbox database， provide a database name that is unique within the organization.B
For each mailbox database， provide a database name that is unique within the Mailbox server.C
For each mailbox database file， provide a file name that is unique within the organization.D
For each mailbox database file， provide a file name that is unique within the Mailbox server.
考题
多选题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 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 as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）A
Hot backupB
Online backupC
consistent backupD
incremental backupE
inconsistent backup
热门标签
最新试卷