2017微软认证考试模拟练习及答案
QUESTION 1
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?
should use local Service account
should use network Service account
should use domain account
should use local System account
Answer: C
QUESTION 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 database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the
database can be restored to a specific point in time. So what action should you perform to achieve this goal?
should verify that the simple recovery model is used by the database
should verify that the full recovery model is used by the database.
should verify that the checksum page verify option is used by the database
should verify that the bulk-logged recovery model is used by the database
Answer: B
QUESTION 3
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?
the database, you should turn on the TRUSTWORTHY database option
the database, the PAGE_VERIFY database option should be set to CHECKSUM
the database, the database compatibility level option should be set to 10.
the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
Answer: B QUESTION 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?
should backup the master database
should backup the file
should backup the SQL Server registry hive.
should backup the resource database
Answer: C
QUESTION 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. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored
procedures that do not contain this prefix cannot be created by you.
What should you do?
A.A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.
B.A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.
C.A condition should be created. The condition targets the name of the stored procedure that is evaluated on change
D.A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.
Answer: B
QUESTION 6
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 an Internet Information Services application. This application will use anonymous access to access the SSAS instance. You must make sure that the application can access the SSAS
instance. What should you do?
SecurityRequireClientAuthentication server configuration should be set to False
SecurityRequireClientAuthentication server configuration should be set to True.
NTLM Security Support Provider Interface (SSPI) provider should be added to the SecuritySecurityPackageList server configuration.
Kerberos Security Support Provider Interface (SSPI) provider should be added to the SecuritySecurityPackageList server configuration
Answer: A
QUESTION 7
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 for a new application, a SQL Server 2008
instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access
to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application
environments.
What should you do?
should install SQL Server 2008 as the default instance, and configure the new application to use the default instance
should upgrade the SQL Server 2005 application to use SQL Server 2008
should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance
should install SQL Server 2008 as a named instance, and make the new application use the new instance.
Answer: D
QUESTION 8
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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM
for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data.
You must make sure that FILESTREAM data is enabled. Which service should you configure?
should configure SQL Server VSS Writer
should configure Distributed File System
should configure SQL Server
should configure SQL Server Full Text
Answer: C
QUESTION 9
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 two instances both of
which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext
indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You must make sure the query can
return records that contain the word "root". What should you do?
should terminate and restart the MSFTESQL service
should rebuild the full-text index
word "root" should be added to the stop list
word "root" should be added to the thesaurus file
Answer: B
QUESTION 10
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 must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what
action should you perform to achieve this goal?
should use the Database Engine Tuning Advisor.
Microsoft SQL Server Management Studio, you should create a maintenance plan
should use the SQL Server Configuration Manager
Microsoft SQL Server Management Studio, you should create a policy
Answer: D
-
2016年计算机存储试题及答案
1、8个字节含二进制位__________。A.8个B.16个C.32个D.64个答案:D。解析:1B(字节)=8b(位),8B(字节)=8×8=64b(位),故选择D。2、计算机的内存容量可能不同,而计算容量的基本单位都是__________。A.字B.页C.字节D.位答案:C。解析:计算机中采用二进制数进行数据存储...
-
2016下半年计算机二级考试C++试题及答案
1.已知一汉字的国标码是5E38,其内码应是()。A)DEB8B)DE38C)5EB8D)7E58答案:A2.已知三个字符为:a、Z和8,按它们的ASCII码值升序排序,结果是()。A)8、a、ZB)a、8、ZC)a、Z、8D)8、Z、a答案:D3.计算机技术中,下列度量存储器容量的单位中,最大的单位是()。A)KBB)MBC)ByteD)...
-
2016最新计算机二级模拟试题
2016年计算机二级考试在即,本站小编为同学们带来最新二级考试模拟试题,快来练一练吧!一、选择题(每小题1分。共20分)1、设循环队列的存储空间为Q(1:35),初始状态为front=rear=35。现经过一系列入队与退队运算后,front=15,rear=15,则循环队列中的元素个数为()。A.15B.1...
-
2017年计算机一级考试题库和答案
中国计算机网络设备制造行业是改革开放后成长起来的,早期与世界先进水平存在巨大差距;但受益于计算机网络设备行业生产技术不断提高以及下游需求市场不断扩大,我国计算机网络设备制造行业发展十分迅速。下面是关于计算机一级考试题库和答案,希望大家认真阅读!一、...