|
|
|
|
| |
You are using SQL Server for your Data
Warehouse, you installed SQL Server on a server computer that have
five disk arrays,
each disk array has its own high speed disk controller. All of the
SQL Server configuration options are set to their default
values.
You want to improve the SQL server disk access speed
Which the SQL Server configuration option should you change ?
a) max async IO
b) max text repl size
c) lightweight pooling
d) max server memory
e) max worker thread
ANSWER: (a)
-----------------------------------------
Q2 :You create two cubes which are named SalesRecent and
SalesHistory. The SalesRecent cube contains all sales information
for
1999, the SalesHistory cube contains sales information for all the
years from 1980 through 1998. There is one Fact in
SalesRecent for each product sold at each store for each day.
There is one Fact in SalesHistory for each product sold at each
store for each month.
You want to browse Sales Data from these two cubes at the same
time.
What should you do ?
a) Create a new cube named SalesMerge and include one partition
for SalesRecent and one partition for SalesHistoty.
b) Create a virtual cube named SalesMerge that include both
SalesRecent and SalesHistoty
c) Import the data from SalesRecent into SalesHistoty
d) Import the data from SalesHistoty into SalesRecent
ANSWER: (c)
-----------------------------------------
Q3 :
You are creating a Data Transformation Services package to import
Data on a monthly basis into a Data Mart in SQL
Server. One
of the source databases is named dbProductionData. An OLE DB
Provider is not available for dbProductionData. This database is
able to export its data to comma delimited text files. The
dbProductionData database has an ODBC driver available.
You need to concatenate columns named LastName and FirstName into
a single column named FullName.
You want to spend as little time as possible in creating the
import process.
What should you do ? (Choose Two)
a) Export the data from dbProductionData to a Text File
b) Use the Microsoft OLE DB Provider for ODBC to access the data
from dbProductionData
c) Use a Data Transformation to import the data from
dbProductionData
d) Use bulk Insert Task to import the data from dbProductionData
e) Use an Execute SQL Task to import data from dbProductionData
ANSWER: (b), (c)
-----------------------------------------
Q4 :
You have an SQL Server Data Mart named ShippingData. You also have
an applicaton that uses comma delimited text files.
You want to import the data from one of the text files to five of
the tables in ShippingData once each week. You need to
modify values in several of the columns in order to make the
values conform to your uniforme data standards.
You want to create a Task to perform the modification, and you
want to create this Task with the least a lot of
administrative effort.
You create a DTS package, What else must you do ?
a) Create one connection for the Text File and one connection for
ShippingData Create one Transform Data Task Use one ActiveX
Transformation Script in the Transform Data Task to open
connection and insert the new Data into the five Tables in
ShippingData
b) Create one connection for the Text File and one connection for
ShippingData Create one Transform Data Task Use five
ActiveX Transformation Script in the Transform Data Task to open
connection and insert the new Data into the five Tables in
ShippingData
c) Create one connection for the Text File and one connection for
ShippingData Use an ActiveX Script Task to open connection
to the five Tables in ShippingData Use global variables to hold
the connection object variable for those five connection
Create one Transform Data Task Use five ActiveX Transformation
Script in the Transform Data Task to insert the new Data into
each of the five Tables in ShippingData
d) Create one connection for the Text File and five connections
for ShippingData Create five Transform Data Task Use one
ActiveX Transformation Script in each of the five Transform Data
Task to insert the new Data into the five tables in
ShippingData
e) Create one connection for the Text File and five connections
for ShippingData Create five Data Driven
Query Tasks Use an
Insert query in each of the five Data Driven Query Tasks to insert
the new Data into each of the five Tables in ShippingData
ANSWER: (d) |
|
|
|
|
|
