Which is the correct answer?
You are developing a SQL Server 2008 Reporting Services (SSRS) instance for
Company.com.
You use the SSRS Report Wizard to develop the report which is based on a Microsoft SQL
Server 2008 Analysis Services (SSAS) dataset.
The dataset is composed of a one measure called Total Sales, and two dimension attributes
called Store Name and Month.
You should pull the Total Sales measure to a report section to display a table with values for
Total Sales for every month. Which is the correct answer?
Which Transact-SQL query should you use?
You administer a Microsoft SQL Server 2012 database that includes a table named Products. The
Products table has columns named Productld, ProductName, and CreatedDateTime.
The table contains a unique constraint on the combination of ProductName and CreatedDateTime.
You need to modify the Products table to meet the following requirements:
Remove all duplicates of the Products table based on the ProductName column.
Retain only the newest Products row.
Which Transact-SQL query should you use?
Which is the correct answer?
You are developing a SQL Server 2008 Reporting Services (SSRS) report which utilizes a
Table data region and includes a dataset which owns a column called TestName for
Company.com.
You should make sure that the report items are grouped through the first character in the
TestName column.
Which is the correct answer?
Which is the correct answer?
You are creating a SQL Server 2008 Reporting Services (SSRS) report which would be
contained in the application which is distributed to remote users who own no access to the
server for Company.com.
You should make sure that the application produces the report normally. Which is the correct
answer?
You need to prevent the locking of the Sales.Inventory table when a single region is updated
You are a database developer. You develop a database by using SQL Server 2008 in an
enterprise environment. The database has a table named Sales.Inventory. The table is
partitioned into four geographic regions. You update the Sales.Inventory table for each
region by using the following stored procedure. CREATE STORED PROCEDURE
usp_Update @RegionID tinyint AS UPDATE Sales.Inventory SET Qty = T.CurrentQuantity
FROM Sales.Inventory I JOIN Sales.TempData T ON I.ItemID = T.ItemID AND I.RegionID =
@RegionID; The UPDATE statement locks the Sales.Inventory table when a single region
is updated. You need to prevent the locking of the Sales.Inventory table when a single
region is updated. What should you do?
Which solution should you implement?
You administer a SQL Server 2008 infrastructure. The infrastructure contains SQL Server
2008 servers across four sites. All sites are connected via a WAN link. All sites use the
same database application. Your company has the following business requirements: All
sites maintain data related to their site. Each site has access to data related to other sites.
In the event of any site failure, database activity is redirected to another site. You need to
implement a replication topology that meets the business requirements. Which solution
should you implement?
Which is the correct answer?
You are creating a SQL Server 2008 Reporting Services (SSRS) instance which includes a
parameter called
Type that is utilized to filter some products for Company.com.
You could utilize a dataset to include query listed below:
SELECT Item.ProductID, Item.Name, Item.ListPrice
FROM Production. Product AS Item
WHERE Item.Category = @ Type;
You should change the parameter to permit values. You should make sure that you could
change the report to help search for Type values through utilizing fewer effort.
Which is the correct answer?
Which is the correct answer?
You are creating a SQL Server 2008 Reporting Services (SSRS) package which includes a
parameter named @ProductID for Company.com.
Through choosing a specific region you should configure the value of the @ ProductID
parameter in the report.
You should make sure that you set the report to prevent users from changing the value of
the @
ProductID parameter.
Which is the correct answer?
Which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) instance for
Company.com.
There is a cube in an SSAS instance.
Because the queries operate not as fast as usual, you should affirm which queries run slowly
and change the storage setting of the cube.
Which is the correct answer?
You need to configure a strategy that will provide the minimum amount of latency for committed transactions
You administer a SQL Server 2008 instance. You plan to design a high-availability solution
by using database mirroring. The current application includes programming logic that will
retry transactions if a failover occurs. You need to configure a strategy that will provide the
minimum amount of latency for committed transactions. What should you do?