PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

what should you do to successfully add the custom data flow component to the toolbox?

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. According to the requirement of the company CIO, you are
using Business Intelligence Development Studio to edit a SQL Server 2008 Integration
Services (SSIS) package.
A custom data flow component is used by the package which runs successfully.
You try to add another instance of the custom data flow component to the package, but you
find that the data flow component does not appear in the toolbox or in the Choose Toolbox
Items dialog box.
You have to solve this problem. So what should you do to successfully add the custom data
flow component to the toolbox?

Which Transact-SQL query should you use?

Your database contains a table named Purchases. The table includes a DATETIME column named
PurchaseTime that stores the date and time each purchase is made. There is a non-clustered index
on the PurchaseTime column.
The business team wants a report that displays the total number of purchases made on the current
day.
You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?

You need to ensure that the following requirements are met: ·The surrogate key is unique across all serve

You are a database developer for a retail application. You create a database by using SQL

Server 2008 in a distributed enterprise environment that has multiple servers. The same
database is implemented on all the servers. The database contains a table that has a
surrogate key. You need to ensure that the following requirements are met: ·The surrogate
key is unique across all servers. ·The index on the surrogate key is not fragmented because
of INSERT operations. 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.
According to the requirement of the company CIO, you use SQL Server 2008 Integration
Services (SSIS) to create a package. The exhibit below shows the structure of the package.
You have to define a variable. The variable contains sensitive information that can only be
accessed by the Sequence Container, the Data Flow Task, and the Execute SQL Task.
What action should you perform?

what should you do to accomplish this task?

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.
According to the requirement of the company CIO, you design a SQL Server 2008
Integration Services (SSIS) data flow. The data flow inserts data from a source query to a
destination table. But now you must make sure that only those rows that do not already exist
in the destination table are inserted. So what should you do to accomplish this task? (choose
more than one)

You need to ensure that the transaction uses a two-phase commit

You administer a SQL Server 2008 infrastructure. You administer two SQL Server 2008
instances named Instance1 and Instance2. Instance1 contains the Sales database, and
Instance2 contains the Accounts database. A procedure in the Sales database starts a
transaction. The procedure then updates the Sales.dbo.Order table and the
Accounts.dbo.OrderHistory table through a linked server. You need to ensure that the
transaction uses a two-phase commit. 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.

You make modification on a SQL Server 2008 Integration Services (SSIS) package. Look at
the following SQL Server 2008 table. The package loads the data extracted from a text file to
this table.
Now you receive an order from your company CIO, the package has to be updated to extract
data from multiple text files of the same directory.
In order to achieve this goal, what should you do? (Choose more than one)

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 dimension named Number and a time dimension named Day.
A column named PresentBalance is contained in a fact table. PresentBalance contains the
current account balance.
A measure named NumberBalance has to be created from the PresentBalance column.
The NumberBalance is used to display the closing account balance for a time period. So
what action should you perform?

which expression should be used?

You are a database developer and you have about two years experience in reating 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.
Your solution includes a time dimension named DimDay.
And the DimDay dimension contains a hierarchy named Yr-Qtr-Mth.
There is a measure group named Measures01 which contains a measure named Number.
Now a calculated member has to be created, then it will be used to display the Number
measure in the previous time period for the current level of the Yr-Qtr-Mth hierarchy.
In the following options, which expression should be used?