Transition MCTS on SQL Serv 08 to MCSA: SQL Serv 2012, Pt 1
Exam Number/Code : 70-457 Exam
Questions and Answers : 90 Q&As
Update Time: 2014-03-03
Price: $ 108.00 $ 143.00 Source:www.testonside.com
http://www.testonside.com/70-457.html
http://www.testonside.com/pdf/70-457.pdf
Question:
You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents. You need to ensure that the documents must only be accessible via Transact-SQL queries. Which Transact-SQL statement should you use?
A. CREATE TABLE DocumentStore AS FileTable
B. CREATE TABLE DocumentStore([Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,[Document] VARBINARY(MAX) FILESTREAM NULL)GO
C. CREATE TABLE DocumentStore([Id] [INT] NOT NULL PRIMARY KEY,[Document] VARBINARY(MAX) NULL)GO
D. CREATE TABLE DocumentStore([Id] hierarchyid,[Document] NVARCHAR NOT NULL);GO
Answer: C Source:www.testonside.com
Question: Source:www.testonside.com
You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition: CREATE TABLE Inventory(ItemID int NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL) You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. Which Transact-SQL statement should you use?
A. ALTER TABLE InventoryADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)
B. ALTER TABLE InventoryADD TotalItems = ItemsInStore + ItemsInWarehouse
C. ALTER TABLE InventoryADD TotalItems AS ItemsInStore + ItemsInWarehouse
D. ALTER TABLE InventoryADD ItemsInStore + ItemsInWarehouse = TotalItems
Answer: D
Question: Source:www.testonside.com
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?
A. Install Master Data services.
B. Install Data Quality services.
C. Create an Integration Services catalog.
D. Create SSIS configuration files for the packages.
Answer: C
Question:
You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?
A. Start the SQL Server Browser Service.
B. Start the SQL Server Integration Services Service.
C. Use the Data Quality Client to configure the application.
D. Use the Master Data Services Configuration Manager to configure the application.
Answer: A Source:www.testonside.com
Question:
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?
A. Common table expressions
B. Synonyms
C. Temporary tables
D. Views
Answer: D
Question:
You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition. CREATE VIEW vOrdersWITH SCHEMABINDINGASSELECT o.ProductID, Source:www.testonside.com
o.OrderDate,
SUM(od.UnitPrice * od.OrderQty) AS AmountFROM OrderDetails AS od INNER JOIN
Orders AS o ON od.OrderID = o.OrderIDWHERE od.SalesOrderID = o.SalesOrderIDGROUP BY o.OrderDate, o.ProductIDGO You need to ensure that users are able to modify data by using the view. What should you do?
A. Modify the view to an indexed view.
B. Create an AFTER trigger on the view.
C. Create an INSTEAD OF trigger on the view.
D. Modify the view to use the WITH VIEW_METADATA clause.
Answer: C
Exam Number/Code : 70-457 Exam
Questions and Answers : 90 Q&As
Update Time: 2014-03-03
Price: $ 108.00 $ 143.00 Source:www.testonside.com
http://www.testonside.com/70-457.html
http://www.testonside.com/pdf/70-457.pdf
Question:
You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents. You need to ensure that the documents must only be accessible via Transact-SQL queries. Which Transact-SQL statement should you use?
A. CREATE TABLE DocumentStore AS FileTable
B. CREATE TABLE DocumentStore([Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,[Document] VARBINARY(MAX) FILESTREAM NULL)GO
C. CREATE TABLE DocumentStore([Id] [INT] NOT NULL PRIMARY KEY,[Document] VARBINARY(MAX) NULL)GO
D. CREATE TABLE DocumentStore([Id] hierarchyid,[Document] NVARCHAR NOT NULL);GO
Answer: C Source:www.testonside.com
Question: Source:www.testonside.com
You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition: CREATE TABLE Inventory(ItemID int NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL) You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. Which Transact-SQL statement should you use?
A. ALTER TABLE InventoryADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)
B. ALTER TABLE InventoryADD TotalItems = ItemsInStore + ItemsInWarehouse
C. ALTER TABLE InventoryADD TotalItems AS ItemsInStore + ItemsInWarehouse
D. ALTER TABLE InventoryADD ItemsInStore + ItemsInWarehouse = TotalItems
Answer: D
Question: Source:www.testonside.com
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?
A. Install Master Data services.
B. Install Data Quality services.
C. Create an Integration Services catalog.
D. Create SSIS configuration files for the packages.
Answer: C
Question:
You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?
A. Start the SQL Server Browser Service.
B. Start the SQL Server Integration Services Service.
C. Use the Data Quality Client to configure the application.
D. Use the Master Data Services Configuration Manager to configure the application.
Answer: A Source:www.testonside.com
Question:
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?
A. Common table expressions
B. Synonyms
C. Temporary tables
D. Views
Answer: D
Question:
You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition. CREATE VIEW vOrdersWITH SCHEMABINDINGASSELECT o.ProductID, Source:www.testonside.com
o.OrderDate,
SUM(od.UnitPrice * od.OrderQty) AS AmountFROM OrderDetails AS od INNER JOIN
Orders AS o ON od.OrderID = o.OrderIDWHERE od.SalesOrderID = o.SalesOrderIDGROUP BY o.OrderDate, o.ProductIDGO You need to ensure that users are able to modify data by using the view. What should you do?
A. Modify the view to an indexed view.
B. Create an AFTER trigger on the view.
C. Create an INSTEAD OF trigger on the view.
D. Modify the view to use the WITH VIEW_METADATA clause.
Answer: C