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
-
微軟認證MCSE證書的有效期
一般來説,IT企業為了使證書持有者的專業水平能夠跟上自身產品的升級以及技術的不斷更新,其頒發的IT認證證書均有一個有效期。然而各個公司的證書有效期的制定策略卻是不一樣的。一般分為固定有效期和不定有效期兩種,前者如CISCO的證書一般為3年(CCNA,CCDA,CCNP,CCDP)...
-
微軟認證考試最新認證
2012年,微軟認證計劃進行了全面升級,以涵蓋雲技術相關的解決方案。新一代微軟認證基於產品與技術解決方案共有以下四個認證路徑:1、Client:1)MCSA:Windows8此認證可證明持證者有能力勝任配置、管理及維護企業級Windows8系統,通過兩項考試70687、70688即可獲得此認證...
-
2017年微軟認證考試模擬試題
微軟認證是具備相當含金量和實用價值的高端證書。新一代的Microsoft認證是更為具體,並且目標更為明確,以反映出專業能力的詳細數據。下面是小編整理的關於微軟認證考試模擬試題,歡迎大家參考!1.您有一台運行WindowsVista的計算機。您在計算機的新分區上安裝Window...
-
微軟面試題及答案
第一組1.燒一根不均勻的繩,從頭燒到尾總共需要1個小時。現在有若干條材質相同的繩子,問如何用燒繩的方法來計時一個小時十五分鐘呢?2.你有一桶果凍,其中有黃色、綠色、紅色三種,閉上眼睛抓取同種顏色的兩個。抓取多少個就可以確定你肯定有兩個同一顏色的果凍?3.如...