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

You need to recommend a solution to minimize the amount of time it takes to execute USP_1.
With what should you recommend replacing Table1?

• A.A temporary table
• B.A view
• C.A function
• D.A table variable

You are creating a database that will store usernames and credit card numbers for an application.
You need to recommend a solution to store and reuse the credit card numbers in the database.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

• A.Encrypting File System (EPS)
• B.Data hashing
• C.Data encryption
• D.Transparent Data Encryption (TDE)

You have a SQL Server instance on a server named Server1.
You need to recommend a solution to perform the following tasks every week: Rebuild the indexes by using a new fill factor. Run a custom T-SQL command. Back up the databases. What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
---

• A.A trigger
• B.A system policy
• C.Windows PowerShell
• D.An alert
• E.A maintenance plan

You have four databases that are accessed by using an Online Transaction Processing (OLTP) application. The databases are stored on a server named SQL1 that has SQL Server 2014 installed.
You plan to deploy an additional server that has SQL Server 2014 installed.
You need to design a high-availability solution for the databases that meets the following
requirements:
If SQL1 fails, the databases must be available.
Users must be able to run reports against a secondary copy of the databases.
What should you include in the design?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Database mirroring
• B.Failover Clustering
• C.AlwaysOn availability groups
• D.Log shipping

You are designing a Windows Azure SQL Database for an order fulfillment system. You create a table named Sales.Orders with the following script.

Each order is tracked by using one of the following statuses:
----
Fulfilled Shipped Ordered Received
You need to design the database to ensure that that you can retrieve the following information:
---
The current status of an order
The previous status of an order.
The date when the status changed.
The solution must minimize storage.
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes.
• B.To the Sales.Orders table, add three columns named Status, PreviousStatus and ChangeDate. Update rows as the order status changes.
• C.To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate. Update the value of each column from null to the appropriate date as the order status changes.
• D.Implement change data capture on the Sales.Orders table.