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

Which data type should you use for CustomerID?

• A.bigint
• B.char(11)
• C.nvarchar(11)
• D.varchar(11)

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 have a SQL Server 2012 database named database1. Database1 has a data file named databasel_data.mdf and a transaction log file named databaseljog.ldf. Databasel_data.mdf is 1.5 GB. Databaseljog.ldf is 1.5 terabytes.
A full backup of Database1 is performed every day.
You need to reduce the size of the log file. The solution must ensure that you can perform transaction log backups in the future.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

• A.Option F
• B.Option C
• C.Option E
• D.Option D
• E.Option A
• F.Option B

Your company has a SQL Azure subscription.
You implement a database named Database1. Database1 has two tables named Table1 and Table2. You create a stored procedure named sp1. Sp1 reads data from Table1 and inserts data
into Table2.
A user named User1 informs you that he is unable to run sp1.
You verify that User1 has the SELECT permission on Table1 and Table2.
You need to ensure that User1 can run sp1. The solution must minimize the number of permissions assigned to User1.
What should you do?

• A.Change sp1 to run as the sa user.
• B.Add User1 to the db_datawriter role.
• C.Grant User1 the INSERT permission on Table2.
• D.Grant User1 the EXECUTE permission on sp1.

You need to implement security for the restore and audit process. What should you do?

• A.Grant the COFFECORP\Auditors group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\StoreAgent group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions.
• B.Grant the COFFECORP\Auditors group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\StoreAgent group CONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions.
• C.Grant the COFFECORP\Auditors group ALTER ANY CONNECTION and IMPERSONATE ANY LOGIN permissions. Grant the COFFECORP\StoreAgent group ALTER ANY CONNECTION and SELECT ALL USER SECURABLES permissions.
• D.Grant the COFFECORP\Auditors group CONNECT ANY DATABASE and SELECT ALL USER SECURABLES permissions. Grant the COFFECORP\StoreAgent group CONNECT ANY DATABASE and IMPERSONATE ANY LOGIN permissions.