READ Free Dumps For Microsoft- 70-462
| Question ID 18869 | You administer a Microsoft SQL Server 2012 database.
You configure Transparent Data Encryption (TDE) on the Orders database by using the
following statements:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MyPassword1!'
CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate';
BACKUP CERTIFICATE TDE_Certificate TO FILE = ''d:\TDE_Certificate.cer'
WITH PRIVATE KEY (FILE = 'D:\TDE_Certificate.key', ENCRYPTION BY PASSWORD =
'MyPassword1!');
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;
ALTER DATABASE Orders SET ENCRYPTION ON;
You attempt to restore the Orders database and the restore fails. You copy the encryption
file to the original location.
A hardware failure occurs and so a new server must be installed and configured.
After installing SQL Server to the new server, you restore the Orders database and copy
the encryption files to their original location. However, you are unable to access the
database.
You need to be able to restore the database.
Which Transact-SQL statement should you use before attempting the restore?
|
| Option A | ALTER DATABASE Master SET ENCRYPTION OFF;
|
| Option B | CREATE CERTIFICATE TDE_Certificate FROM FILE = 'd:\TDE_Certificate.cer' WITH PRIVATE KEY (FILE = 'D:\TDE_Certificate.key', DECRYPTION BY PASSWORD = 'MyPassword1!');
|
| Option C | CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate'; USE Orders; CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;
|
| Option D | CREATE CERTIFICATE TDE_Certificate FROM FILE = 'd:\TDE_Certificate.cer';
|
| Correct Answer | B |
Explanation
| Question ID 18870 | You develop a Microsoft SQL Server 2012 database. The database is used by two web
applications that access a table named Products. You want to create an object that will
prevent the applications from accessing the table directly while still providing access to the
required data.
You need to ensure that the following requirements are met:
✑ Future modifications to the table definition will not affect the applications' ability to
access data.
✑ The new object can accommodate data retrieval and data modification.
You need to achieve this goal by using the minimum amount of changes to the
applications.
What should you create for each application?
|
| Option A | Synonyms
|
| Option B | Common table expressions
|
| Option C | Views
|
| Option D | Temporary tables
|
| Correct Answer | C |
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ms190174.aspx