070-432 試験問題を無料オンラインアクセス

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database
named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs.
The backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Thursday at
17:00 hours.
You need to restore the backup.
What should you do?

• A.Restore the backup taken on Sunday only.
• B.Restore the backup taken on Wednesday only.
• C.Restore the backups taken on Wednesday and Friday.
• D.Restore the backups taken Wednesday, Friday, and Saturday.
• E.Restore the backups taken on Wednesday, Thursday, and Friday.
• F.Restore the backups taken on Sunday and Monday.
• G.Restore the backups taken on Wednesday and Thursday at 09:00 hours.
• H.Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
  18:00
  hours.

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?

• A.The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration.
• B.The Security\RequireClientAuthentication server configuration should be set to True.
• C.The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration
• D.The Security\RequireClientAuthentication server configuration should be set to False

You are mastering the company database called TesterDB; the database includes a database that uses SQL Server log shipping. Log shipping will happen half a hour. You should make the full backup.
In order to cut the net bandwidth utilization when maintenance every night.
Which is the correct answer?

• A.You should disable log shipping after the nightly maintenance.
• B.You should reproduce only those indexes that ask it every night.
• C.You should set the database to utilize the bulk-logged recovery model.
• D.You should add the time during transaction log backups.

You are managing a SQL Server 2008 instance which includes some applications for
Home.com.
You set the SQL Server Agent service to implement through utilizing the SerTest\Test account.
You create a job named MailingTester that allows a file to be stored to a log server. The job could not run normally because it could not own proper access to the log server.
You decide to set the service of SQL Server Agent.
You should make sure that you could run the settings such that the SQL Server Agent service owns all access to the log server. Which is the correct answer?

• A.You should utilize the type of remote System account
• B.You should utilize the type of Domain account
• C.You should utilize the type of remote Service account
• D.You should utilize the type of Local Service account

You administer a SQL Server 2008 instance.
You join two tables on a column named CompanyName by using the following query:
SELECT s.*,i.*
FROM SensitiveTb1 AS s
INNER JOIN Insensitive Tb1 AS iON i. CompanyName = s.CompanyName
When you execute the query, the following error is returned: "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between ,SQL_Latinl_General_CPl_CS_AS' and
'SQL_Latin1_General_CP1_CI_AS' in the equal to operation."
You need to modify the ON clause of the query to successfully perform a case-sensitive
join.
What should you do?

• A.ON UPPER(i.CompanyName) = UPPER(s.CompanyName)
• B.ON i.CompanyName = s.CompanyName COLLATE SQL_Latin1_General_CP1_CS_AS
• C.ON i.CompanyName = s.CompanyName COLLATE SQL_Latin1_General_CP1_CI_AS
• D.ON LOWER(i.CompanyName) = LOWER(s.CompanyName)