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 code segment should you use?
You need to create a stored procedure that accepts a table valued parameter named @Customers.
Which code segment 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 data type should you use?
You are creating atable that stores the GPS location of customers.
You need to ensure that the table allows you to identify customers within aspecifiedsales boundary and to calculate the distance between a custom er and the nearest store. Which data type should you use?
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?
Which TransactSQL statement should you use?
You need to write a query that uses a ranking function that returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
Which TransactSQL statement 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?
Which query should you use?
You have a table named Sales.
You need to return sales data ordered by customer name. For each customer, the most recent sale must be listed first.
Which query should you use?