070-464 무료 덤프문제 온라인 액세스

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the following specifications:
Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of the time.
Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution must minimize the storage requirements for the tables. Which options should you recommend? To answer, drag the appropriate options to the correct column in the answer area.

정답:

Explanation:
http://msdn.microsoft.com/en-us/library/cc280604.aspx
http://msdn.microsoft.com/en-us/library/ms186241.aspx

You need to create the object used by the parameter of usp_UpdateEmployeeName.
Which code segment should you use?

• A.CREATE TABLE EmployeesInfo
• B.CREATE XML SCHEMA COLLECTION EmployeesInfo
• C.CREATE SCHEMA EmployeesInfo
• D.CREATE TYPE EmployeesInfo AS Table

The database contains a disk-based table named ContentTable that has 1 million rows and a column named Fax. Fax allows null values.
You need to update Fax to meet the following requirements:
Prevent null values from being used.
Always use an empty string instead of a null value.
Which statement or statements should you execute? (Each correct answer presents part of the solution. Choose all that apply.)

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

An administrator provides a digital certificate named ServerCert.
You need to implement Transparent Data Encryption (TDE) on ProductsDB.
Which code segment should you use?

• A.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256
  ENCRYPTION BY SERVER CERTIFICATE DBCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• B.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY
  ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• C.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256
  ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• D.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY
  ENCRYPTION BY SERVER CERTIFICATE DBCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO

You execute the following code:

You need to select the task that has an IsFinished value of true from the Project that has an Id value of 1.
Which code segment should you use?

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