PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

You need to identify the best model to replicate data by using minimum development efforts

You administer a SQL Server 2008 instance named Instance1 at the New York central site.
Your company has a sales team to fulfill purchase orders for customer requests. The sales
team uses portable computers to update data frequently in a local database. When the
portable computers connect to the central site, the local database must be synchronized
with a database named Sales. You plan to create a replication model to replicate the local
database to the Sales database. The replication model must meet the following
requirements: Data conflicts are handled when multiple users update the same data

independently. The sales team cannot update sensitive data such as product price. The
sales team can synchronize data at scheduled times and on demand also. You need to
identify the best model to replicate data by using minimum development efforts. What
should you do?

What action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.

You work as the technical support. Now you receive an e-mail from your company CIO, in
the email, the CIO assigns a task to you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution. You enable
proactive caching for a partition.
A data source view (DSV) is added to the solution. The DSV contains a table which is
named Worker.
The table has two columns: WorkerKey and ExecutiveKey.
The ExecutiveKey column references the executive of the workers.
In the DSV, you have to define the relationship between the employees and their manager.
What action should you perform?

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI)by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.
Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) instance.
There is a database in the instance.
After the DataDir property of the instance is changed to a new folder, you must make sure
that the instance uses the new folder with as little downtime as possible.
So what action should you perform?

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.
You work as the technical support. Now you receive an e-mail from your company CIO, in
the email, the CIO assigns a task to you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
There is a time dimension named DimDay in the solution.
There is a table named FinishedSales. This table contains two columns both of which refer
to the DimDay dimension.
The two columns are respectively named BillDate and MailDate.
Now you get an e-mail from your company CIO, in the e-mail the CIO posts a requirement.
The DimDay dimension must be able to be used to browse through measures in the
FinishedSales table for both BillDate and MailDate.
You have to ensure this. So what action should you perform?

Which action will you perform to finish the task?

You are a professional level SQL Sever 2008 Database Administrator. It is reported by the
customers that the server performance degraded due to a newly implemented process.
Dynamic Management Views is utilized to confirm that no long running queries exist. The
operating system performance data should be correlated with the actual query execution
trace, and the least administrative effort should be utilized. Which action will you perform to
finish the task?

what action should be performed?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.

Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to
you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
The solution contains a dimension named DimDay and a measure group named
FinishedSales.
The DimDay dimension contains an attribute which is named Week. The FinishedSales
references the DimDay dimension. According to the requirement of the company CIO, you
must make sure that the aggregations designed on FinishedSales always include the Week
attribute.
So what action should be performed?

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company

named NaproStar which uses SQL Server2008. You work as the technical support. Now you
receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You
use SQL Server 2008 Reporting Services (SSRS) to create a solution. There is a table in the
solution. The table is named FinishedBills. The table contains two columns respectively
named BillKey and ClientKey. You have to create a measure, the number of customers who
have placed bills is returned by the measure. So what action should you perform?

You need to ensure that the stored procedure performs the given tasks

You are a database developer. You plan to design a database solution by using SQL Server
2008. You create a stored procedure that uses the TRY/CATCH syntax in a new database.
When the stored procedure is executed, it logs information about each step in the TRY
block into a table named dbo.ExecutionLog. When an error occurs, the stored procedure
must perform the following tasks: ·Roll back the changes made to the target tables. ·Retain
the log entries stored in the dbo.ExecutionLog table. You need to ensure that the stored
procedure performs the given tasks. What should you do?

what should you do?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work
as the technical support.
Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to
you.
You use SQL Server 2008 Reporting Services (SSRS) to create a project.
Data from a SQL Server 2005 Analysis Services database will be displayed by the report.
According to the requirement of the company CIO, you must make sure that member
properties and extended properties are displayed by the report.
So what should you do?