1) When the model contains two data sources
that provide date values, how can the developer avoid ambiguity when
Transformer sets the current time period?
A. Disable the data source's ability to set
the current time period.
B. Assign the current date (obtained from
the system clock) as the current period.
C. Let Transformer assign the date closest
to the model's creation date as the current period.
D. Enter the initial current period and
adjust it to match the system date and time.
Answer: A
2) Where can a developer change
relationships to create a structure different from what the data suggests?
A. Categories Diagram
B. Dimension Map
C. Data source property sheet
D. Level property sheet
Answer: A
3) What must be done to make the cube data
available in Analysis Studio?
A. Use the PowerCube Connection Utility to
publish the cube.
B. Create a data source connection to the
cube in Transformer.
C. Publish the PowerCube as a data source
and a package.
D. Generate a package that contains a data
source connection to the cube.
Answer: C
4) A developer added a manual level in the
time dimension. During category generation, the developer gets a warning that
Transformer is not able to relate
the categories to the parent levels. What
must be done to ensure Transformer relates the categories correctly?
A. Specify a date function for each level.
B. Specify date input format.
C. Specify an Invalid Dates category.
D. Specify a time-state rollup.
Answer: A
5) What can be done if a regular time
dimension is added to a model, and the levels Year, Quarter, and Month are not
automatically generated?
A. Set the date input format for the time
dimension.
B. Set the data class of the source
category to Date.
C. Change the numeric time sequence for
each level.
D. Create a non-standard time dimension
with the new levels.
Answer: B
6) Senior Managers need to see total and
regional sales figures, but Regional Managers should see relevant figures for
only their regions.
Where can the developer specify the degree
of detail to be included?
A. In a manual level
B. In a cube group
C. In the PowerCube
D. In a scenario dimension
Answer: B
7) How can a developer customize the
reporting period so that the year has 52 weeks, with 7 days in each week,
yielding 364 days?
A. Set up a lunar time period.
B. Set up a time period based on a calendar
year.
C. Set up a time period based on fiscal
year.
D. Set up a relative time category.
Answer: A
8) If a cube group based on a level in a
dimension is created, how can the developer prevent another cube from being
added to the cube group?
A. Ensure the level labels and category
labels remain unchanged.
B. Specify a category limit for the level.
C. Prevent the automatic creation of
categories.
D. Exclude the dimension from
auto-partitioning.
Answer: C
9) How can a developer populate a level
with a different data source column?
A. Through level properties.
B. Through column properties.
C. Through data source properties.
D. Through data source scope.
Answer: A
10) What can be done to correct a report
that contains time categories that are out of range and irrelevant to the user?
A. Ensure the input format is correct for
dates in the source data.
B. Check to see if an absolute range
category is automatically generated.
C. Adjust the acceptable dates included in
the model.
D. Create a non-standard time dimension.
Answer: C
11) How can the parent-child relationship
for each category be established?
A. Verify the model.
B. Insert manual levels.
C. Show category counts.
D. Generate the categories.
Answer: D
12)The developer notices a decrease in
run-time performance in a model that has calculated measures (before rollup).
Because auto-partitioning is not used,
how
can the developer increase performance?
A. Use a duplicates rollup instead of a
before rollup setting.
B. Use an external rollup instead of a
before rollup setting.
C. Use calculated columns instead of before
rollup measures.
D. Use a time state rollup instead of
before rollup setting.
Answer: C
13)How can a developer include a key
performance indicator that is unavailable in the Transformer data source?
A. Add a manual category.
B. Add a calculated measure.
C. Create a cube group.
D. Add a measure allocation.
Answer: B
14) What can be done to show how many
retailers of each type bought a specific product each month, quarter, or year?
A. Create a calculated measure with a Time
state rollup.
B. Specify an allocated measure as the
Activity Measure.
C. Create a calculated column.
D. Define a measure that counts categories.
Answer: D
15)The model contains a measure named
Quantity, and the OLAP reports need to show the Minimum monthly quantity sold
to each store. How would a developer get the correct result?
A. Use a Regular rollup function.
B. Use a Time state rollup function.
C. Use an External rollup function.
D. Use a Non-regular rollup function.
Answer: A
16) For a cube that represents values in
Euros, what should be done for American consumers to see the appropriate
currency symbol in Euros?
A. Build Cubes using a system locale that
matches the measure locale.
B. Manually create and update the base
currency information.
C. Set up currency conversion without
defining a default currency.
D. Use more than one data source to supply
the conversion rates.
Answer: A
17) When measures are calculated after
rollup, when are the calculations performed?
A. Before time state rollup takes place.
B. After allocated measures are calculated.
C. Before regular rollup takes place on all
measures.
D. After relative time calculations.
Answer: B
18) How can a developer best address values
that are being rounded excessively?
A. Adjust the number of decimal places.
B. Create a calculated measure.
C. Modify the rollup operations.
D. Assign scale and precision settings.
Answer: D
19) For performance reasons, what is the
best parent-child ratio for categories in each level?
A. 1:10 or less
B. 1:11 or more
C. 5:1 or less
D. 10:1 or more
Answer: A
20) Transformer is unable to locate one of
the source files for a data source in the model, and the model update fails.
Which type of files can be used to restart the processing at the point of
failure?
A. .py?
B. .qy?
C. .mdl
D. .mdx
Answer: B
21) How can the cube build flexibility and
performance be maximized?
A. Enable Consolidation.
B. Enable the AutoSummarize property.
C. Combine Structural and Transactional
data into one data source.
D. Preprocess the data.
Answer: D
22) Where should fact queries against OLAP
sources come from?
A. A flat file
B. An .iqd file
C. A Cognos 10 report
D. A Cognos 10 package
Answer: A
23) What does a unique move ensure when
applied to a level in a dimension map?
A. The measure values are not rolled up to
the new path of the moved categories.
B. The category can be moved to another
level.
C. The developer must manually restructure
the categories in the dimension.
D. The category moved within the level has
its data history moved with it.
Answer: D
24) Which of the following can be done to
improve performance when dealing with large volumes of data?
A. Include multiple data sources.
B. Use a single large data source.
C. Include transactional and structural
data sources of the same type.
D. Use Cognos 10 reports as transactional
and structural data sources.
Answer: A
25) To add dimensional data to an existing
model, how can metadata be leveraged from other published OLAP packages?
A. Insert an OLAP package in the data
source list.
B. Import a PowerCube as a data source.
C. Add dimensions from an OLAP package in
the dimension map.
D. Add a data source query using a Cognos
10 OLAP report.
Answer: C
26) What should a developer do if some
levels appear red after validating the model using Show Scope?
A. Ensure the level exists in the data
source.
B. Specify a valid relationship between the
level and the data source.
C. Re-attach the categories in the
Dimension Diagram.
D. Apply unique move to the level and
regenerate the categories.
Answer: B
27) Which of the following will help
improve processing time when Transformer queries the data?
A. Use normalized structural data sources.
B. Separate structural and transactional
information in multiple data sources.
C. Combine structural and transactional
information into one data source.
D. Define dimensions within a transactional
data source with unique values.
Answer: B
28) What does unique mean when applied to a
level in a dimension map?
A. The level is designated as a convergence
level.
B. The level must be the bottom level of
the dimension.
C. No two categories in the level can be
derived from the same source value.
D. The data history does not move with the
categories as they move in the level.
Answer: C
29) A Cognos 10 report with prompts is used
as a data source. What must be done to create a second query that is
based on the same report but provides
different values for mandatory prompts?
A. Add the second query to the report data
source.
B. Refresh the source when adding the
second query.
C. Add prompt values to the cache in the
Transformer data source.
D. Add the same report as another
Transformer report data source.
Answer: D
30) When can Transformer category codes
change?
A. When a new cube is defined.
B. When a reset partition is applied.
C. When the cube connection is updated with
pcconn.
D. When a Clean House is performed before a
cube is rebuilt.
Answer: D
31) What modeling factor affects the
auto-partitioning strategy and causes poor consolidation for partitioned
categories?
A. Wide, flat dimensions
B. Well-balanced hierarchical dimensions
C. Allocated measures
D. After rollup calculated measures
Answer: A
32) Columns have been renamed in the data
source. Which command must the developer run to update the model?
A. Check Columns
B. Update Columns
C. Rename columns
D. Modify Columns
Answer: D
33) How can a developer rebuild an
incrementally updated cube?
A. Enable time-based partitioning and
rebuild the cube.
B. Clean house and rebuild the cube.
C. Save the model, and revert to the backup
.mdl file.
D. Delete the old .mdc file and recreate
the entire cube.
Answer: D
34) A developer notices that tildes (~)
exist in the category codes. What can be done to avoid unstable MUN values?
A. Perform a Clean House.
B. Resolve the non-unique keys within a
dimension in the data source.
C. Regenerate the categories.
D. Ensure the values are non-conformed in
the data source.
Answer: B
35) What improves performance in the
reporting application by combining records with identical non-measure values?
A. Consolidation
B. Partitioning
C. PC Optimizer
D. Crosstab caching
Answer: A
36) When running simultaneous cube builds,
how can cube build times be decreased?
A. Assign each Transformer process one CPU.
B. Assign each Transformer instance one
CPU.
C. Use the same configuration files for
each Transformer instance.
D. Use a single-CPU server model.
Answer: A
37) What can the developer specify for the
cube build to use multiple directories to generate temporary work files?
A. Log files
B. Model temporary files
C. Operating system page file
D. Data temporary files
Answer: D
38) How can a cube be built with data
volumes that result in a .mdc file larger than 2 GB?
A. Set the MultiFileCubeThreshold value to
zero.
B. Enable the creation of multiple local
PowerCube files.
C. Remove the auto-partitioning scheme.
D. Use multiple checkpoint files.
Answer: B
39) What could be done if the report does
not run after the category codes change?
A. Rebuild the cube and publish a new
package.
B. Perform a Clean House.
C. Modify the report to point to the
updated member.
D. Manually change the category codes
within the model.
Answer: C
40) As a good practice, what can a
developer do to be prepared in case a model develops conflicts or becomes
corrupt?
A. Keep a backup .mdl file.
B. Keep a backup .py? file.
C. Keep a backup qy? file.
D. Keep a backup .py? and qy? files.
Answer: A
41) What does the developer specify when
creating a test build that uses a subset of the source data?
A. The number of categories.
B. The dimensions to include in the cube.
C. The number of records.
D. The measures to include in the cube.
Answer: C
42) Where are the log files accessed to
troubleshoot issues?
A. In the Content store.
B. In the Bin folder in the installation
directory.
C. In the path set in Transformer
preferences.
D. In the Temp directory.
Answer: C
43) At the beginning of the fiscal year,
the Camping Equipment product line reduced the number of products that are
being sold.
What can be done to remove the inactive
categories that are no longer needed in the model?
A. Set the level inclusion to suppress
categories that are not needed.
B. Incrementally update the Powercube.
C. Prevent the automatic generation of new
categories.
D. Generate the categories.
Answer: A
44) How does a developer associate a custom
view with a PowerCube?
A. Update the Powercube properties.
B. Specify the path of the Powercube in the
custom view.
C. Specify the package name in the custom
view.
D. Drag the custom view to the appropriate
Powercube.
Answer: D
45) To control access to content for users
that have similar responsibilities and privileges,where should security be
applied?
A. Data source
B. Role
C. User
D. Namespace
Answer: B
46) How is the PowerCube updated once
changes are made to a custom view?
A. The cube must be rebuilt.
B. The custom view should be re-defined.
C. The changes are automatically updated.
D. Security objects must be re-assigned.
Answer: A
47) In Transformer, how can a developer
restrict access to an entire PowerCube from authorized users?
A. Apply cube-based security.
B. Set member-based security.
C. Apply namespace-level security.
D. Set package-based security.
Answer: A
48) A group called Authors is used in a
custom view. How is information updated if the Author group members change in
the authentication provider?
A. The PowerCube must be rebuilt.
B. The services must be restarted in Cognos
Configuration.
C. The changes are automatically updated at
run time.
D. The package must be republished.
Answer: C
49) What objects can be created within the
Cognos Namespace?
A. Roles and users
B. Groups and roles
C. Groups and users
D. Members
Answer: B
50) How can a developer define a specific
view of the data and restrict access to it?
A. Apply cube-based security.
B. Set member-based security.
C. Apply namespace-level security.
D. Set package-based security.
Answer: B
51) What can be done to apply member-based
security if the model contains cube groups?
A. Define the security for each member
cube.
B. Inherit the security that was used in
the control cube.
C. Create a hierarchical custom view.
D. Create a descendant custom view.
Answer: A
52) What can be created if the financial
analyst wants to look at the data by fiscal year,
while the senior manager wants to analyze
the data by calendar year?
A. An alternate hierarchy in the time
dimension.
B. A subdimension in the time dimension.
C. A special category.
D. A calculated category.
Answer: A
53) What can be applied to a category if
only the parent and child categories are required?
A. Suppress
B. Exclude
C. Summarize
D. Cloak
Answer: A
54) The time dimension contains levels for
year, quarter, and month. How can the month levels in 2008 be retained while
removing them from 2007?
A. Add a special category.
B. Add a manual level.
C. Create a scenario dimension.
D. Create a subdimension.
Answer: D
55) What must be unique to create an
alternate hierarchy?
A. The top level
B. The highest level in a dimension
C. The lowest level in a dimension
D. The level of convergence
Answer: D
56) What can a developer set up to analyze
actual, planned, and forecasted budget information that do not rollup into a
single root category?
A. Scenario dimension
B. Calculated category
C. Special category
D. Exception dimension
Answer: A
57) The dimensions in the model include
Product, Customer, and Order. If the Powercube should focus on the sales
orders,
how can the developer remove customer data?
A. Omit the dimension from the PowerCube.
B. Apex the dimension in the model.
C. Set measure allocation for the Customer
dimension.
D. Suppress the dimension in the model.
Answer: A
58) The Region dimension is organized by
Territory, Country, and City. Which option can be applied to only show data for
the United States and its descendants?
A. Suppress
B. Apex
C. Summarize
D. Cloak
Answer: B
59) A dimension organizes all the regions
by Country and City. Disregarding the hierarchical organization, how can the
five best performing regions be grouped?
A. Create a scenario dimension.
B. Add an alternate drill-down path.
C. Add a special category.
D. Create a subdimension.
Answer: C
60) When there are too many child
categories, what can be created to allow intermediate groupings?
A. A cube group
B. An alternate drill-path
C. A manual level
D. A subdimension
Answer: C
61) A developer created a cube for each
regional Sales Manager. Each cube should contain only the transactional details
for each Sales Manager's region,
as well as the summarized values for other
regions. What should be created?
A. Custom view
B. Cube group
C. Apexed view
D. Suppressed view
Answer: B
62) What can be created to determine the
monthly growth showing the percentage of change between Current Month and Last
Month for all measures
included in the PowerCube?
A. Calculated columns
B. Calculated categories
C. Calculated measure
D. Alternate hierarchies
Answer: B
63) Which option decreases cube size by
removing data from the cube?
A. Suppress
B. Summarize
C. Apex
D. Cloak
Answer: C
64) What can be done in a manual level to
keep new data separate until it can be connected to the appropriate parent
category?
A. Create an orphanage category.
B. Create a special category.
C. Include categories when needed.
D. Prohibit automatic creation of new
categories.
Answer: A
65) What can be created to provide new
insight into the data if Margin Ranges are defined as Low, Medium, and High,
based on a calculated
column using the revenue and cost columns?
A. Scenario dimension
B. Exception dimension
C. Special category
D. Calculated category
Answer: B
No comments:
Post a Comment