Which component should you use to reduce collision issues on a large LAN?()
第1题:
Your network contains a server named Server1. The Active Directory Rights Management Services (AD RMS) server role is installed on Server1. An administrator changes the password of the user account that is used by AD RMS. You need to update AD RMS to use the new password. Which console should you use()
第2题:
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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? ()
第3题:
You have a computer that runs Windows 7. You need to identify the disk, memory, CPU, and networkresources that an application is currently using. Which tool should you use?()
第4题:
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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? ()
第5题:
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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? ()
第6题:
You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services. Configuring name resolution and network access and so on.Your company is desigiing its network. The network will use an IPv6 prefix of 2001:DB8: BBCC:0000::/53. You have to identify an IPv6 addressing scheme that will support 2000 subnets. Which network mask should you use?()
第7题:
You should use SQLServer:Buffer Manager
You should use SQLServer:Memory Manager
You should use SQLServer:Databases
You should use SQLServer:Access Methods
第8题:
You should use row compression
You should use page compression
You should use backup compression
You should use windows NTFS file system compression
第9题:
MAX
MIN
SUM
COUNT
TOTAL
LARGEST
第10题:
You should use the Database Engine Tuning Advisor tool
You should use the Windows System Monitor tool
You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio
You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
第11题:
You should backup the master database
You should backup the default.trc file
You should backup the SQL Server registry hive.
You should backup the resource database
第12题:
SMB
RTSPS
CIFS
HTTPS
第13题:
Which clause should you use to exclude group results?()
第14题:
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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? ()
第15题:
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. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use? ()
第16题:
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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? ()
第17题:
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. There is a n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table. In the options below, which compression technology should you use?()
第18题:
You should use /63.
You should use /64.
You should use /61.
You should use /62.
第19题:
Programs > Programs and Features
Appearance and Personalization > Ease of Access Center
System and Maintenance > Problem Reports and Solutions
System and Maintenance > Performance Information and Tools/
第20题:
WHERE
HAVING
RESTRICT
GROUP BY
ORDER BY
第21题:
You should use Dynamic Management Views
You should use SQL Server Resource Governor
You should use SQL Server Profiler
You should use Windows System Monitor
第22题:
You should use database snapshots
You should use database backup and restore
You should use database backup and restore along with compression
You should use schema-bound views in a read-only database. The database resides on the same instance.
第23题:
You should use local Service account
You should use network Service account
You should use domain account
You should use local System account
第24题:
Host
Switch
Printer
Repeater