A company would like to distribute reports to users via an email address or a directory entry. How should the burst table be defined for this to work appropriately?
A. Directory entries must not use the alternate path syntax.
B. The burst table can be an uploaded file and contain as many columns as needed.
C. The burst table must contain three columns (Recipient, Recipient type and Data item) to burst on.
D. The directory entry can use either the alternate path syntax or the internal search path using the CAMID.
A report author uploads files into Cognos Analytics ?Reporting.
Which file formats are supported? (Choose two.)
A. Microsoft Excel formatted single sheet worksheets.
B. Any text or Microsoft Excel spreadsheet (xlsx or xls).
C. Text files with data separated by commas, colons, tabs or semi-colons.
D. Text files with data separated by commas, tabs, semi-colons or pipes.
E. Text files must be fixed length without any separator denoting columns.
A report author has been asked to create a list report with multiple facts from across the business. The desired outcome must ensure correlated and predictable results.
Which item must be included in the list report?
A. Repeater table
B. Conditional fact
C. Model Query subject
D. Conformed dimension
A report contains multiple queries that are joined to form the report, resulting in poor performance. The company's policy prohibits the use of user-defined SQL statements within reports.
What should be done to improve report performance?
A. Convert the report to use Native SQL statements.
B. Move the appropriate filters to the underling queries.
C. Change the Cross Product allowed property to be "Deny".
D. Modify the Query Execution method to Concurrent to ensure that the underlying queries run at the same time.
A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.
How should the report be changed?
A. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
B. Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.
C. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report.
D. Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place the Crosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.
A company's marketing report tracks performance of various advertising campaigns. All of the advertising media files are stored on an internal file server and can be accessed directly in the URI form file://adserver/ adnnnnnn.mov (where nnnnnn is the same advertisement ID that's used in the marketing performance report).
How can the report author provide users with a clickable download link for the media file in the report performance list?
A. Add a Layout Calculation to the list as a new column with expression definition `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.
B. Add a pair of HTML Items to the Ad Name list cell, using a Report Expression that includes `file:// adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.
C. Add a Drill-through definition to the Ad Name list cell, using a Bookmark target with Report Expression of: `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.
D. Insert an Image object into the Ad Name list cell, with URL Source Type set to Report Expression and using expression: `file://adserver/ad' + [PerformanceQuery].[AdID] + `.mov'.
A report author wants to display the report name on the report page.
Which type of calculation should be used?
A. Field set
B. Singleton
C. Query calculation
D. Layout calculation
An author wants to include a corporate graphic in the Dashboard.
Which image format is supported?
A. SVG
B. BMP
C. TIFF
D. JPEG
What should a report author do to use data from two tabs of an Excel file (.xlsx) together in a single object in a Dashboard?
A. Upload each tab as one upload file and merge together within a data module.
B. Upload each tab as separate upload files and merge together within a data module.
C. Create separate Excel files for each tab, upload the files as one upload file and merge together within a data module.
D. Create separate Excel files for each tab, upload the files as separate upload files and merge together within a data module.
Which statement is true when a report author wants to optimize reports for mobile users?
A. Set objects to a fixed size.
B. Use margins between report objects.
C. Size objects as a percentage of the available space.
D. Use percentage sizes greater than one hundred percent (100%).
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-621 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.