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 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 to achieve this?
You’re the administrator of your company network. And you are in charge of a Microsoft SQL Server 2005 Reporting Services (SSRS) instance which is deployed as a single server and configured to use Native mode. Besides this, the instance also has another feature: A custom data extension developed by using Microsoft .NET Framework 2.0. Now you intend to upgrade the instance to SQL Server 2008 Reporting Services without loss of functionality. So what should you do to achieve this?
Which code segment should you use?
You have two tables named SalesPerson and SalesTerritory.
You need to create sample data by using a Cartesian product that contains the data from the SalesPerson and SalesTerritory tables.
Which code segment 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 design a Business Intelligence (BI) solution.
There is a SQL Server 2008 Analysis Services (SSAS) cube which contains 110 million Fact rows and 750 dimension attributes. The cube reads data from a remote data source and increases several measure groups by 1 million rows everyday. You intend to deploy this SQL Server 2008 Analysis Services (SSAS) cube. You want to increase the total number of users by 180 percent
for the cube. During cube processing, you have to capture the baseline performance on the overall system. So what should you do?
Which query should you use?
You have two tables named Customers and Orders.
For customers that have placed at least one order, you need to produce a list of customer names and the number of orders for each customer.
Which query should you use?
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 join predicate should you use?
You are a database developer. You plan to design a database solution by using SQL Server 2008.
You have a database that contains a table and a table-valued function. The table valued function accepts the primary key from the table as a parameter.
You plan to write a query that joins the table to the results of the table-valued function.
You need to ensure that only rows from the table that produce a result set from the table-valued function are returned.
Which join predicate 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 Transact-SQL statement should you use?
You have the two tables as shown in the following exhibit (Click the Exhibit button.).
The foreign key relationship between these tables has CASCADE DELETE enabled.
You need to remove all records from the Orders table.
Which Transact-SQL statement should you use?