You need to implement the monitoring process by using the minimum amount of administrative effort
You administer a SQL Server 2008 infrastructure. The instance contains a database
required for the day-to-day business of your company. Users experience slow response
time when they execute reports. You plan to design a performance monitoring strategy that
captures and stores the following data: Executed Transact-SQL statements and query
activity. Blocking and deadlock information. Counters for disk, CPU, and memory. You
need to implement the monitoring process by using the minimum amount of administrative
effort. What should you do?
Which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) database for
Company.com.
You get the Duplicate Key error when you operate the Analysis Services database.
You should alter the ErrorConfiguration attribute in order to make processing run normally.
Which is the correct answer?
which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) database for
Company.com.
In order to update data in a partition each hour you should run the incremental processing
method.
In order to solve the problem, which is the correct answer?
Which is the correct answer?
You are developing a SQL Server 2008 Reporting Services (SSRS) report for
Company.com.
Assembly should be created in order to run real-time lookup and currency conversion.
The assembly has a static class named daily which lives in the namespace HomeCalc. there
is a
method called DMO which need two arguments, Cuurnt and HomeCalc
When the report is operating, you should reference the ToEUR method in an expression to
convert USD to USO.
Which is the correct answer?
You need to resolve the performance problems without affecting the server performance
You administer a SQL Server 2008 infrastructure. An instance contains a database that
includes a large table named OrderDetails. The application queries only execute DML
statements on the last three months data. Administrative audits are conducted monthly on
data older than three months. You discover the following performance problems in the
database. The performance of the application queries against the OrderDetail table is poor.
The maintenance tasks against the database, including index defragmentation, take a long
time. You need to resolve the performance problems without affecting the server
performance. What should you do?
Which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) instance which includes a
database for Company.com.
You alter the DataDir attribute of the instance to a new folder.
You should make sure that instance utilizes the new folder in least time.
Which is the correct answer?
Which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a
dimension called Product for Company.com.
You should set the Dimension Data configurations as following:
Deny access to the {[ Product].[Country].[USA],[ Product].[Country].[China]} configure of
property workers.
New workers increased to the property are seen by default. Which is the correct answer?
Which Transact-SQL statement or statements should you use?
You develop a Microsoft SQL Server 2012 database.
You need to create and call a stored procedure that meets the following requirements:
Accepts a single input parameter for CustomerID.
Returns a single integer to the calling application.
Which Transact-SQL statement or statements should you use? (Each correct answer presents part of
the solution. Choose all that apply.)
Which strategy should you use?
You are a database developer. You plan to design a database solution by using SQL Server
2008. A table in a database will store large image files (20-50 MB in size). You have the
following business requirements: ·The image files are accessible by applications that use
Win32 APIs. ·The image files are part of the database backup. You need to identify an
appropriate strategy to store the image files. Which strategy should you use?
Which is the correct answer below?
You are creating SQL Server 2008 Integration Services (SSIS) packages which is stored in a
folder on the network for Company.com.
All members of the team can view the packages but not the attribute values.
Your task is to make the attribute values be protected by password.
Which is the correct answer below?