默认题库 - MCITP(70-450)

单选题

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 is managed by you. A database is utilized by the instance, and the database is utilized by a Web-based application. 15,000 transactions are processed by the application every minute. A column is contained by a table in the database, and the column is utilized only by the application. Sensitive data is stored in this column. The sensitive data should be stored with the highest security level. In addition, the least amount of memory space and processor time should be utilized. From the following four encryption types, which one should you utilize?（）

Asymmetric key encryption should be utilized.
B. Certificate-based encryption should be utilized.
C. Symmetric key encryption should be utilized.
D. Transparent data encryption should be utilized.

查看答案

单选题

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 should be managed by you. The computer on which the instance run has the following three features: a 64-GB RAM, four quad-core processors, and several independent physical raid volumes. A transactional database will be implemented on the instance. In addition, the database should have a high volume of INSERT, UPDATE, and DELETE activities. Creation of new tables is contained by the activities. You need to maximize disk bandwidth and decrease the contention in the storage allocation structures so as to have the performance of the database optimized. Which action will you perform to finish the task?（）

A. To finish the task, database and log files should be placed on the same volume.
B. To finish the task, the affinity mask option should be configured properly.
C. To finish the task, multiple data files should be create for the database.
D. To finish the task, the affinity I/O mask option should be configured properly.

查看答案

单选题

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 should be managed. It is reported by the customers that the server performance degraded due to a newly implemented process. Dynamic Management Views is utilized to confirm that no long running queries exist. The operating system performance data should be correlated with the actual query execution trace, and the least administrative effort should be utilized. Which action will you perform to finish the task?（）

A. To finish the task, Data Collector should be utilized.
B. To finish the task, the SQLdiag.exe utility should be utilized.
C. To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.
D. To finish the task, SQL Server Profiler and System Monitor should be utilized.

查看答案

单选题

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 infrastructure is managed by you. A database is included by the instance, and a table named EmployeeData is contained by the database. There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are stored in the column. The space utilized by the Profile column should be cut to the least. In addition, a reasonable performance should be maintained to retrieve the content of the column. Which action will you perform?（）

A. ROW compression should be utilized for the EmployeeData table.
B. The Profile column should be stored by utilizing filestream storage， and the NTFS file system Compression should be utilized.
C. PAGE LEVEL compression should be utilized for the EmployeeData table.
D. The Profile column should be implemented as a CLR user-defined type.

查看答案

多选题

You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements. Which two actions should you perform?（）

A. Use NTFS file system compression on the volume.
B. Use row-level compression on the document table.
C. Use varbinary(MAX) data type with FILESTREAM storage.
D. Enable row-level compression on all columns that use the vardecimal() data type.

查看答案

单选题

在多机通信中，主机发送数据时，将TB8设置为0的含义是：（）

A. 第8位地址为0
B. 第8位数据为0
C. 发送地址
D. 发送数据

查看答案

单选题

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. SQL Server 2008 instances at five sites are managed by you.A mission-critical database is shared by the five sites. According to the business requirements, the users at each site should be enabled to access and change data on all sites with minimal latency.In addition, data loss should be minimized if a server fails. A high-availability solution should be designed, and the business requirements should be satisfied. Which action should be included in your solution?（）

A. Failover clustering should be included.
B. Asynchronous database mirroring without a witness server should be included.
C. Peer-to-Peer replication should be included.
D. Log shipping to servers at two of the sites to offer read-only replications of data should be included.

查看答案

单选题

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 database solution is managed by you. All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE statements are utilized by the procedures. A backup strategy should be implemented. The business requirements listed below should be satisfied. Point-in-time recovery for failure is supported by the backup strategy at any time of day. In addition, the least amount of disk space should be utilized by the transaction log. Which action should you perform to finish the task?（）

A. To finish the task, hourly database snapshots should be utilized.
B. To finish the task, the full-recovery model along with transaction log backups should be utilized.
C. To finish the task, the full-recovery model along with differential backups should be utilized.
D. To finish the task, the simple-recovery model along with differential backups should be utilized.&e

查看答案

单选题

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 infrastructure is managed by you. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table. Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent. A strategy should be designed to have the performance of the queries on the table optimized. Which action will you perform?（）

A. The clustered index of the Orders table should be dropped.
B. The clustered index of the Orders table offline should be rebuilt once a month.
C. The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.
D. The clustered index of the Orders table should be reorganized by reducing the fill factor.

查看答案

单选题

You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure that you minimize the usage of memory space and processor time. Which encryption type should you use?（）

A. Symmetric key encryption
B. Asymmetric key encryption
Certificate-based encryption
D. Transparent data encryptio

查看答案