70-462 무료 덤프문제 온라인 액세스

You administer a Microsoft SQL Server database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?

• A.an operator
• B.a proxy
• C.a schedule
• D.an alert

You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Microsoft SQL Server 2012. All databases are hosted on a SAN (Storage Area Network).
You need to design a database solution for a new application.
You are tasked with designing a high-availability database solution.
The solution must include a single copy of the database to save disk space and the database must remain online in the event of a SQL Server failure. What should you include in your solution?

• A.You should include two servers and log shipping.
• B.You should include two servers configured as a failover cluster.
• C.You should include two servers and database mirroring.
• D.You should include two servers configure as a SQL Server Availability Group

You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.
When SQL Server Agent jobs fail, the error messages returned by the job steps do not provide the required detail.
The following error message is an example error message:
"The job failed. The Job was invoked by User CONTOSO\ServiceAccount. The last step to run was step 1 (Subplan_1)." You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained.
What should you do?

• A.Disable the Limit size of job history log feature.
• B.Configure output files.
• C.Expand agent logging to include information from all events.
• D.Configure event forwarding.

You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server 2008 R2 64-bit server.
You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same server. You also need to ensure that the new Transact-SQL functionality in SQL Server 2012 can be used in the database after the migration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Detach the database from the old instance and attach it to the new instance.
• B.Perform an in-place upgrade to 64-bit SQL Server 2012.
• C.Change the compatibility level of the database.
• D.Perform a side-by-side installation of a 64-bit SQL Server 2012 instance.
• E.Perform a side-by-side installation of a 32-bit SQL Server 2012 instance.

You have the following table.

You need to create a full-text index for the table.
Which two statements should you execute? Each correct answer presents part of the solution.

• A.CREATE FULLTEXT STOPLIST KnowledgeBaseStopListFROM KnowledgeBase
• B.CREATE RULE KnowledgeBaseRuleAS @Problem LIKE '%'
• C.CREATE FULLTEXT INDEX ON KnowledgeBase(Problem, Solution) KEY INDEX
  PK_KnowledgeBase ON OurKB
• D.CREATE FULLTEXT CATALOG [Catalog] WITH ACCENT_SENSITIVITY =
  ONAUTHORIZATION [dbo]
• E.CREATE INDEX OurIndex ON KnowledgeBase(Problem, Solution) ON [Catalog]