PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which data type should you use?

You are designing a database that contains a data definition language (DDL) trigger. The
DDL trigger will provide the maximum amount of data available when any attempt is made
to change the database schema. You need to design a table to meet the following
requirements: ·Accept the EVENTDATA information that is provided by the trigger ·Support
the searching and retrieval of nodes and values ·Minimize development time Which data
type should you use?

Which SSRS technology should be used to achieve this goal?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Reporting Services (SSRS) for the company.
To meet the business requirements, you use SSRS to develop a production report with a
table contained.
Now you get an order from your company CIO, according to his requirement, when users
click on a field in the table, a SSRS technology should be executed to open a new report for
them.
Which SSRS technology should be used to achieve this goal?

What action should you perform to achieve this goal?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Reporting Services (SSRS) solution for the company. Then you add a
report with a query parameter and a single dataset to the solution.
Now you get an order from your company CIO, according to his requirement, you need to
make sure that the report can be executed with no user interaction from the Report
Manager.
What action should you perform to achieve this goal?

You need to assign the least permission necessary to MarketingUser

Your SQL Server 2008 database contains two tables named Customer and Order inside the
Sales schema. The Sales schema is defined as follows: It has a stored procedure named
SetCustomerStatus that reads from Order and modifies Customer. It is owned by a user
named SalesUser. Another user named marketingUser wants to be able to call
SetCustomerStatus and change the status of Customer. You need to assign the least
permission necessary to MarketingUser. What should you do? (More than one answer
choice may achieve the goal. Select the BEST answer.)

what action should be performed to accomplish the tasks above?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Reporting Services (SSRS) solution for the company.
You use the solution to create a report, and then write the code segment in the report that is
shown as the following:
Private Shared Function GetMFromMeters(ByVal MetersPrice As Decimal) As Decimal If
IsNothing
(MetersPrice) Then
Return Nothing
Else
Return MetersPrice * 1.78
End If
End Function
However, when you compile code segment, you will get errors.

Now you get an order from your company CIO, according to his requirement, not only you
should get the call of the GetMFromMeters function from other reports, but also you should
have the code segment compiled without any errors.
So what action should be performed to accomplish the tasks above?

which one object should be used?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Analysis Services (SSRS) for the company.
You are in charge of a SSAS database that is contained on a default instance.
According to your plan, the Analysis Services performance information will be documented
by the computer.
In order to achieve this goal, information related to the temporary file usage should be
collected at the time of processing the database.
So of the following objects, which one object should be used?

what action should you perform to achieve that goal?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Analysis Services (SSRS) for the company.
You are in charge of a SSAS database that is configured with the use of multiple security
roles.
There is a Microsoft ASP.NET application running on a remote computer.
Then in order access the database, Windows Authentication is used to configure the
application.
Now you get an order from your company CIO, according to his requirement, you have to
make sure that the SSAS database can be accessed successfully by the users of the
application.
Besides, you have to make sure that you apply security restrictions of the roles on SSAS.
So what action should you perform to achieve that goal?

You need to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours

Your SQL Server 2008 server has only the SQL Server service running. All other SQL
Services are disabled. You have a user named DBReportsUser. You need to restrict
DBReportsUser to login only between 17:00 hours and 22:00 hours. You want to achieve
this goal by using the minimum amount of administrative effort and the least impact on the
Server security. What should you do? (More than one answer choice may achieve the goal.
Select the BEST answer.)

Which tool below would be used to accomplish this task?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and you are in charge of a
SQL Server 2008 Analysis Services (SSRS) instance for the company.

Now you are assigned a task to have the analysis services query log configured for the
SSAS instance.
Which tool below would be used to accomplish this task?