Microsoft MCITP 70-454 시험은 IT업종종사분들에게 널리 알려진 유명한 자격증을 취득할수 있는 시험과목입니다. Microsoft MCITP 70-454시험은 영어로 출제되는만큼 시험난이도가 많이 높습니다.하지만 Pass4Test의 Microsoft MCITP 70-454덤프만 있다면 아무리 어려운 시험도 쉬워집니다. 오르지 못할 산도 정복할수 있는게 Pass4Test제품의 우점입니다. Pass4Test의 Microsoft MCITP 70-454덤프로 시험을 패스하여 자격증을 취득하면 정상에 오를수 있습니다.
NO.1 You manage a SQL Server 2008 database that is located at your company's corporate
headquarters.The database contains a table named dbo.Sales.You need to create different views of the
dbo.Sales table that will be used by each region to insert, update, and delete rows.Each regional office
must only be able to insert, update, and delete rows for their respective region.Which view should you
create for Region1?
A.CREATE VIEW dbo.Region1Sales AS SELECT SalesID,OrderQty,SalespersonID,RegionID FROM
dbo.Sales WHERE RegionID = 1;
B.CREATE VIEW dbo.Region1Sales AS SELECT SalesID,OrderQty,SalespersonID,RegionID FROM
dbo.Sales WHERE RegionID = 1 WITH CHECK OPTION;
C.CREATE VIEW dbo.Region1Sales WITH SCHEMABINDING AS SELECT
SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID = 1;
D.CREATE VIEW dbo.Region1Sales WITH VIEW_METADATA AS SELECT
SalesID,OrderQty,SalespersonID,RegionID FROM dbo.Sales WHERE RegionID = 1;
Answer: B
NO.2 You plan to add a new column named SmallKey to the Sales.Product table that will be used in a unique
constraint.You are required to ensure that the following information is applied when adding the new
column:
'a1' and 'A1' are treated as different values 'a' and 'A' sort before 'b' and 'B' in an ORDER BY clause You
need to select the collation that meets the requirements for the new column.Which collation should you
select?
A.Latin1_General_BIN
B.SQL_Latin1_General_CP1_CI_AI
C.SQL_Latin1_General_CP1_CI_AS
D.SQL_Latin1_General_CP1_CS_AS
Answer: D
NO.3 You are creating a new table in a database.Your business requires you to store data in the table for
only seven days.You need to implement a partitioned table to meet this business requirement.Which tasks
should you complete?
A.Create the partition function Create the partition scheme Create the table
B.Create the partition function Create the table Create a filtered index
C.Add a secondary file to the primary filegroups Create the table Create the distributed partitioned view
D.Create the partition function Create the partition scheme Create the distributed partitioned view
Answer: A
NO.4 You need to create a column that allows you to create a unique constraint.Which two column definitions
should you choose? (Each correct answer presents a complete solution.Choose two.)
A.nvarchar(100) NULL
B.nvarchar(max) NOT NULL
C.nvarchar(100) NOT NULL
D.nvarchar(100) SPARSE NULL
Answer: AC
NO.5 You have a table named Customer.You need to ensure that customer data in the table meets the
following requirements: credit limit must be zero unless customer identification has been verified.credit
limit must be less than 10,000.Which constraint should you use?
A.CHECK (CreditLimt BETWEEN 1 AND 10000)
B.CHECK (Verified = 1 AND CreditLimt BETWEEN 1 AND 10000)
C.CHECK ((CreditLimt = 0 AND Verified = 0) OR (CreditLimt BETWEEN 1 AND 10000 AND Verified = 1))
D.CHECK ((CreditLimt = 0 AND Verified = 0) AND (CreditLimt BETWEEN 1 AND 10000 AND Verified =
1))
Answer: C
NO.6 You currently store date information in two columns.One column contains the date in local time and
one column contains the difference between local time and UTC time.You need to store this data in a
single column.Which data type should you use?
A.time
B.datetime2
C.datetime2(5)
D.datetimeoffset
Answer: D
NO.7 You have a table named AccountsReceivable.The table has no indexes.There are 75,000 rows in the
table.You have a partition function named FG_AccountData.The AccountsReceivable table is defined in
the following Transact-SQL statement:
CREATE TABLE AccountsReceivable ( column_a INT NOT NULL, column_b VARCHAR(20) NULL) ON
[PRIMARY];
You need to move the AccountsReceivable table from the PRIMARY file group to FG_AccountData.Which
Transact-SQL statement should you use?
A.CREATE CLUSTERED INDEX idx_AccountsReceivable ON AccountsReceivable(column_a) ON
[FG_AccountData];
B.CREATE NONCLUSTERED INDEX idx_AccountsReceivable ON AccountsReceivable(column_a) ON
[FG_AccountData];
C.CREATE CLUSTERED INDEX idx_AccountsReceivable ON AccountsReceivable(column_a) ON
FG_AccountData(column_a);
D.CREATE NONCLUSTERED INDEX idx_AccountsReceivable ON AccountsReceivable(column_a) ON
FG_AccountData(column_a);
Answer: C
NO.8 You have multiple tables that represent properties of the same kind of entities.The property values are
comprised of text, geometry, varchar(max), and user-defined types specified as 'bit NOT NULL' data
types.You plan to consolidate the data from multiple tables into a single table.The table will use
semi-structured storage by taking advantage of the SPARSE option.You are tasked to identify the data
types that are compatible with the SPARSE option.Which data type is compatible with the SPARSE
option?
A.text
B.geometry
C.varchar(max)
D.A user-defined type defined as 'bit NOT NULL'
Answer: C