首页
微信群
QQ群

微软认证70-228模拟试卷7

网友评分：

关注人数： 0

收藏分享

卷面总分：0分
试卷类型：模拟考试
测试费用：免费
答案解析：是
练习次数：12次
作答时间：30分钟

试卷简介

1.单选题
2.多选题

查看试卷

试卷预览

1: You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.
You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.
Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A．Set the database load state for each destination server to No recovery mode.
B．Set the database load state for each destination server to standby mode.
C．Enable the allow database to assume primary role option for both destination servers.
D．Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.
E．Disable the allow database to assume primary role option for both destination servers.

6: You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.
You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.
The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.
Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)
A. On drive C, create a transaction log.
On drive D, create a data file in the PRIMARY filegroup.
On drive E, create a data file in the SECONDARY filegroup.
B. On each drive, create a transaction log.
On each drive, create a data file in the PRIMARY filegroup.
C. On drive D, create a transaction log.
On drive E, create a data file in the PRIMARY filegroup.
D. On the PRIMARY filegroup, create all tables and all indexes.
E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.
F. On the PRIMARY filegroup, create the Parts table and its indexes.
On the SECONDARY filegroup, create all other tables and their indexes.

1: You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.
You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.
You cancel the SQL Server upgrade wizard.
You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?

A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.
B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.
D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

5: You are the administrator of a SQL Server 2000 computer. The server contains a database that has the torn page detection database option enabled. Backups of the database are made daily.
The server loses power for one minute. When power is restored, torn pages are detected. You notice in SQL Server Enterprise Manager that the database is marked suspect.
You need to correct the problem. What should you do?

A．Execute the DBCC CHECKDB statement, and then specify the PHYSICAL_ONLY option.
B．Execute the DBCC CHECKDB statement, and then specify the REPAIR_REBUILD option.
C．Execute the sp_resetstatus stored procedure.
D．Restore the suspect database from backups.

5: You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database is configured as shown in the exhibit.
In the last six months, the database has grown by 4 GB. Users report that query response time has slowed. The options set up on the database are shown in the Database Options exhibit.
You want to accelerate query response time. What should you do?

A．Update the database statistics.
B．Add indexes to the foreign key fields.
C．Truncate the transaction log.
D．Run the database maintenance plan wizard.
E．Drop primary keys from all tables.

6: Exhibit:
UPDATE EzonexamConsolidated
SET District = ‘Mexico’
WHERE RtvID = 45
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.
When users run the query in the exhibit above the receive the following error message:
Server: Mrh3612, Level 16, Stats 1, Line 1
View or function ‘EzonexamConsolidated’ is not updateable because it
contains aggregates:
How should you enable the query to run?

A．Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.
B．The appropriate users should be granted UPDATE permissions on each base table.
C．To enable updates on the composite tables create an INSTEAD OF trigger on the view.
D．On each base table add a cascading update trigger.

5: You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.
Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.
CREATE PROCEDURE GetCustomer
( @CustomerID Int )

AS    SELECT FirstName, LastName, Address1, Address2, City,    State, Zip, MAX(PurchaseDate) AS LastPurchase
FROM Customers C
JOIN Addresses A ON A.AddressID = C.AddressID
JOIN Purchases P ON P.CustomerID = C.CustomerID    WHERE C.CustomerID = @CustomerID
GROUP BY FirstName, LastName, Address1, Address2, City, State, Zip    You want to improve the performance of the procedure by using the least amount of administrative effort. What should you do?
A．Recompile the stored procedure.
B．Update the database statistics.
C．Check the consistency of the database and repair errors.
D．Create a view and modify the stored procedure to use the view.

10: You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.
You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.
You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?

A．Configure SQLAgentMail to use a valid MAPI profile
B．Configure SQL Mail to use a mailbox that delegates permissions to the operator
C．Use the net send notification method to send the operator e-mail messages
D．Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts

相关试卷

2017年微软认证网络工程师模拟试题

所属类型：模拟考试2021-03-23

2017年微软认证网络工程师模拟试题

所属类型：模拟考试2021-03-23

2017年微软认证网络工程师模拟试题

所属类型：模拟考试2021-03-23

微软认证70-210模拟试卷6

所属类型：模拟考试2021-03-23

微软认证70-210模拟试卷2

所属类型：模拟考试2021-03-23

微软认证70-210模拟试卷7

所属类型：模拟考试2021-03-23

微软认证70-210模拟试卷1

所属类型：模拟考试2021-03-23

微软认证70-210模拟试卷5

所属类型：模拟考试2021-03-23

微软认证70-210模拟试卷3

所属类型：模拟考试2021-03-23

微软认证70-210模拟试卷8

所属类型：模拟考试2021-03-23