PrepAway - Latest Free Exam Questions & Answers

Category: 70-454

Exam 70-454: Upgrade: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD

Which cmdlet should you use?

You have a table named Inventory.
You open a Microsoft Windows PowerShell session at the following location by using the SQL Server Windows PowerShell provider.
PS
SQLSERVER:\SQL\CONTOSO\DEFAULT \Databases\ReportServer\Tables\dbo.Inventory\Columns>
Using the SQL Server Windows PowerShell provider, you need to query all the columns in the table.
Which cmdlet should you use?

Which data type should you use?

You are a database developer. You plan to design a database solution byusing SQL Server 2008.
The database will contain a table to stage data from an external source.The imported data will contain a field named TransactionTime. The Transaction Time field will use the hh:mm:ss.[m] format (such as 12:55:30.1).
You need to select the appropriate data type for the Transaction Time field. You want to achieve this goal by incurring minimum amount of storage cost.
Which data type should you use?

What should you do?

You are a database developer. You plan to design a database solution by using SQL Server 2008.
The database will contain three tables.The structure of the three tables is as shown in the following table.

You need to minimize disk space usage without altering the data types in thetables of the database.
What should you do?

Which cmdlet should you use?

You have a table named Inventory.
You open a Microsoft Windows PowerShell session at the following location by using the SQL Server Windows PowerShell provider.
PS
SQLSERVER:\SQL\CONTOSO\DEFAULT \Databases\ReportServer\Tables\dbo.Inventory\Columns>
Using the SQL Server Windows PowerShell provider, you need to query all the columns in the table.
Which cmdlet should you use?

What isolation level should you use?

You are a database developer. You plan to design a database solution by using SQL Server 2008.
A stored procedurein a database uses a transaction to retrieve data from a table and produces aggregations.
You must design a solution that meets the following requirements:
Update operations cannot be performed on the retrieved data while the stored procedure is being executed.
Insert operations in the table can be performed while the stored procedure is being executed.
You need to ensure that the solution meets the requirements.
What isolation level should you use?

What should you do?

You are a database developer. You provide solutions by using SQL Server 2008 in an enterprise environment.
Your online transaction processing (OLTP) database contains a tabled named SalesOrders. Your data warehouse contains a table named factBuyingHabits. The factBuyingHabits table has no indexes.
You need to synchronize data between the two tables on a weekly basis. The synchronization process has the following requirements:
New records in the SalesOrders table are inserted in the factBuyingHabits table.
When a record is modified in the SalesOrders table,the modificationis updated in the factBuyingHabits table.
Records that are deleted from the SalesOrders table are also deleted from the factBuyingHabits table.
You need to design an appropriate synchronization solution.You want to achieve this goal by using minimum amount of coding and administrative efforts.
What should you do?


Page 1 of 712345...Last »