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?
which backup strategy should you use?
You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution.
Now you manage a SQL Server 2008 instance which hosts a database. At present the database is scheduled for a full backup every month and uses the bulk-logged recovery model. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. You have to back up the database changes to a tape drive every night, you must use as little storage space and time as possible. So which backup strategy should you use?
What should you do?
You are a database developer. You plan todesign a database solution by using SQL Server 2008.
A f requently used query takes very long to execute.
You discover that the query frequently uses full-table scans instead of indexes. This causes other queries that modify the table to be blocked.
The indexing strategy on the underlying tables that the query uses can change.
You need to design a solution that performs the following tasks:
Removes fulltable scans
Allows the query optimizer to select the appropriate index.
What should you do?
which named set expression should you use to achieve this?
You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services (SSAS) solution and then you design a Business Intelligence (BI) solution. There’s a dimension named DEClients in the solution. And the dimension is used to stand for clients who buy products in your company. The solution gives a list of top 8 Clients according to the sales amount. End users of the solution use filters in Microsoft Excel worksheet to analyze data. Now you’re assigned a task to make sure that when the filters are applied, the list must be updated. So which named set expression should you use to achieve this?
Which code segment should you insert a t line 3?
You have a table named Employee. You document your company’s organizational hierarchy by inserting the EmployeeID of each employee’s manager in the ReportsTo column.
You need to write a recursive query that produces a list of employees and their manager. The query must also include the employee’s level in the hierarchy.
You write the following code segment. (Line numbers are included for reference only.)
01 WITH EmployeeList (EmployeeID, FullName, ManagerName, Level)
02 AS (
03
04 )
05 SELECT EmployeeID, FullName, ManagerName, Level
06 FROM EmployeeList
Which code segment should you insert a t line 3?
which backup strategy should you use?
You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution.
Now you manage a SQL Server 2008 instance which hosts a database. At present the database is scheduled for a full backup every month and uses the bulk-logged recovery model. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. You have to back up the database changes to a tape drive every night, you must use as little storage space and time as
possible. So which backup strategy should you use?
Which query should you use?
Your database contains sales information formillions of orders.
You need to identify the orders with the highest average unit price and an order total greater than 10,000. The list should contain no more than 20 orders.
Which query should you use?
what should you do?
You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services (SSAS) solution and then you design a Business Intelligence (BI) solution. The exhibit below presents the data source view of the solution.
You create the components below from the corresponding tables in the data source view:
A measure group named FactSales
Two dimensions named DimCustomer and DimGeography
In the FactSales measure group, you intend to analyze data by geographic location. You have to use the DimGeography dimension to execute the rollup measures in the FactSales measure group. So what should you do?
Which locking hint should you use in RetrieveProducts?
You are a database developer. You plan to design a database solution by using SQL Server 2008.
The database contains a table named Products.
The database has two stored procedures named ModifyProduct and RetrieveProducts. ModifyProduct updates a single row in the Products table. RetrieveProducts returns all rows from the Products table.
RetrieveProducts is used by a report.Users who run the report experience contention problems. You discover that RetrieveProducts is being blocked by ModifyProduct.
The report must not include rows that are currently being modified.
You need to ensure that the report is executed as quickly as possible.
Which locking hint should you use in RetrieveProducts?
which algorithm should you choose to design the solution?
You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. In a Point of Sale (POS) application, your company processes all transaction data. In order to forecast which type of products a customer may buy, you design a solution on the basis of the transactional data. So which algorithm should you choose to design the solution?