Braindumps of QAWI301
These are Guaranteed question for this exam. I only
used www.exams.ws guide and i was succedded.
QUESTION NO: 1
You open a Web Intelligence document (WID) with data
and want to use data tracking. The Data Tracking button
is however grayed out. Which action should you take
to enable formatting of the tracked data?
A. Contact the system administrator.
B. Edit the document in tracking mode.
C. Open the document in tracking mode.
D. Enable data tracking in the Document Properties.
QUESTION NO: 2
You are using calculation contexts within an If() function.
Which two are valid contexts for use in an If() function?
A. In Cell
B. In Row
C. In Block
D. In Report
QUESTION NO: 3
Which DaysBetween() function syntax should you use to
calculate the number of years since your birth, assuming
the date object is Birth_date?
A. =DaysBetween([Birth_date] ; CurrentDate ) / 365.25
B. =DaysBetween([Birth_date] , CurrentDate() ) / 365.25
C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25
D. =DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25
QUESTION NO: 4
Which two statements are true of grouping sets when
using smart measures? (Choose two.)
A. It is a set of dimensions that generates a result
for a measure.
B. It is a set of measures that generates a result for
C. The generated SQL includes grouping sets for all
the aggregations of that dimension that are included
in the report.
D. The generated SQL includes grouping sets for all
the aggregations of that measure that are included in
QUESTION NO: 5
Where in Web Intelligence Rich Client interface can
you see the data source for a document built on a local
A. Global Settings
B. Report Settings
C. Query Properties
D. Document Properties
QUESTION NO: 6
You want to compare the sales revenue performance of
the top 20% of your customers to the average of all
of your customers. You decide to apply a rank on the
table that shows customers and revenue and create a
variable to show the average revenue for all customers.
Which function should you use in the variable?
QUESTION NO: 7
Which two functions can you use to concatenate the strings
"England" and "New" to create the
string "New England"? (Choose two.)
QUESTION NO: 8
Which two statements are true of the Web Intelligence
default behavior when performing a UNION combined query
method? (Choose two.)
A. It performs aUNION.
B. It performs a UNION ALL.
C. It returns all values less the duplicates.
D. It returns all values including the duplicates.
QUESTION NO: 9
Which statement describes the performance impact that
data tracking has on report refresh times, assuming
that the data changes but the number of rows retrieved
and the data volume stays the same?
A. It will refresh up to three times faster.
B. It will refresh up to three times slower.
C. It will refresh faster each time the report is refreshed.
D. It will refresh slower each time the report is refreshed.
QUESTION NO: 10
You are working with a set of store revenues. All stores
have positive revenue values. Which formula should you
use to display the variance value of the Revenue measure
in your document when data tracking is active?
QUESTION NO: 11
Which three methods can you use to combine queries using
the Web Intelligence Rich Client? (Choose three.)
C. UNION ALL
QUESTION NO: 12
Which keyword is defined as flexible for input contexts?
QUESTION NO: 13
You want to force the calculation context for a variable
in a large report with many dimensions. Which operator
allows you to add a dimension to the default context?
QUESTION NO: 14
Which two are running aggregate functions in Web Intelligence?