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

DRAG DROP
You plan to deploy SQL Server 2012.
You identify the following security requirements for the deployment:
- Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the database engine. - All database files and log files must be encrypted if the files are moved to another disk on another server.
You need to identify which feature meets each security requirement. The solution must minimize processor overhead.
Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.

正解：

You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort.
Which code should you use?

• A.Option B
• B.Option A
• C.Option D
• D.Option C

DRAG DROP
You administer a SQL Server 2014 instance.
The server is capable of 10000 IO/second (IOPS). During the time period when the second process executes, the disk IO can reach 7000 IOPS, and CPU use can average 30% over the eight processors.
The first process summarizes the day's activity executed by a login of [SummaryReportLogin]. The second process submits transactions executed by a login of [ETLLogin].
A Resource Governor classifier function has been created to return WG_Low for connections from the [ETLLogin] and [SummaryReportLogin].
You need to set up the Resource Group and Workgroup Pools on the instance.
You have the following requirements:
- Both processes must never use more than 50 percent of the CPU at any one time. - The number of active queries that these processes can execute simultaneously should be limited to a maximum of 10. - The SummaryReportLogin process must always achieve the minimum IOPS required to be minimally affected during executing the ETLLogin processes.
Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.

正解：

You need to create a function that will use a SELECT statement in ProductsByProductType.sql.
Which code segment should you use to complete the function?

• A.Option B
• B.Option A
• C.Option D
• D.Option C

You use SQL Server 2012 to maintain the data used by the applications at your company.
You plan to create a disk-based table named Tablel by using the following statement. (Line numbers are included for reference only.)

You need to ensure that Tablel contains a column named UserName. The UserName column will:
Store string values in any language.
Accept a maximum of 200 characters.
Be case-insensitive and accent-insensitive.
Which code segment should you add at line 03?
---

• A.UserName varchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
• B.UserName nvarchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
• C.UserName nvarchar(200) COLLATE Latin1_General_CS_AS NOT NULL,
• D.UserName varchar(200) COLLATE Latin 1_General_CS_AS NOT NULL,