SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Certified Project Designer Cpd
Start Test
Study First
Subjects
:
certifications
,
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
Very high; part of ETL process
Process for creating the Project Metadata
Attribute Elements
2. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Report Formatting
Lookup Table structure of a completely denormalized schema
MSTR applications
Tasks when defining a User Hierarchy
3. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
4 types of Prompts
By default
Lookup Tables
OLTP
4. Template - Filter - View of a Report
3 components of a Report
Outline Mode
Filter Definition Prompts
Lookup Table structure of a completely normalized schema
5. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Components of a Metric
To create the Project connectivity
Filter Definition Prompts
To edit the appearance of a Graph in a report
6. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Desktop Administrative Functions
Locking and Resizing
Outline Mode
Report Subscription
7. OLAP Services does not add any ______ to the report query.
3 Methods of MSTR Desktop navigation
New SQL
Value Prompts
Components of Compound Metrics
8. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Facts
Report Objects
Attribute Forms
Desktop Architec
9. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Nested Metrics
Lookup Table structure of a completely denormalized schema
Reports
2 components of a Physical Schema
10. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Facts
Types of analysis you can perform with OLAP Services
Project
Attribute or its relationship(s)
11. Direct: 2-tier - Server: 3-tier
Limitations of the Attribute Creation Wizard
OLAP
2 ways you can configure the Project Source to connect to the Metadata database
View Filter
12. Specifies what info to retrieve from a data-warehouse - and how to display it
2 types of Attribute Expression
Report Template
2 options for Sorting
Search-based prompts
13. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Page-by
MSTR Desktop
Lookup Table structure of a completely normalized schema
14. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Cannot create project objects
2 types of Attribute Expression
Hierarchies
MSTR OLAP Services
15. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.
Report Filter operators
4 tasks of the Attribute Creation Wizard
View Filters
2 components of a Physical Schema
16. Facts associated to different column names in 2 or more tables
Heterogeneous Fact
Components of a MSTR architecture
2 types of Attribute Expression
Attribute Forms
17. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Required on the report for Outline Model to work
Aggregate a Metric
The 3 MSTR Tools
Outline Mode
18. Metrics that perform multiple aggregations; one calculation inside of another.
Nested Metrics
5 Report display views
Attribute Creation Wizard good for
Object Prompts
19. Level of OLTP integration
Warehouse Catalog
Nested Metrics
Minimal or none
Source system characteristics
20. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
OLTP
View Filter
Gigabytes (GB)
OLAP
21. A feature that enables users to delivers reports to the history list - cache or mobile
Relationship Tables
Unlimited
Report Subscription
Lookup Tables
22. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Types of analysis you can perform with OLAP Services
2 types of Attribute Relationships
The 3 MSTR Tools
Page-by
23. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Drilling
Heterogeneous Fact
Required on the report for Outline Model to work
Facts
24. The default entry-points.
Highest-level attributes
Project Creation Wizard
Desktop Analyst
Derived Metrics
25. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Report Objects
Facts
Schema
To qualify a Metric in a Set Qualification
26. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Simple Metrics
Metrics
Factors to consider when designing a logical data model
Project-level options/settings
27. Level of OLAP integration
Very high; part of ETL process
Derived Metrics
Report Filter operators
Project Source
28. Allow you to interact with the BI system - logically organize data to analyze complex relationships
2 components of a Physical Schema
Homogeneous Fact
To save a Report Format
MSTR applications
29. Enables you to select which tables from the data-warehouse to store in the Metadata database
2 types of Table Keys
Types of drilling
Cannot create project objects
Warehouse Catalog
30. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
4 types of Report Filters
Derived Metrics
Warehouse Catalog
31. Attribute Creation Wizard - Attribute Editor
Project
Display views you can Print by
Methods are there to creating Attributes
Objects you are allowed to Page-by
32. Must have a one-to-one relationship with all other forms.
Attribute Forms
Object Prompts
Logical Data Model
Facts
33. Used to limit a possibly overwhelming set of potential prompt answers
Report Prompts
Search-based prompts
Derived Metrics
4 types of Report Filters
34. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
To create the Project connectivity
Notes
Report Filter
File types are allowed for exporting a Report
35. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
Attribute or its relationship(s)
User Hierarchies
Desktop Administrative Functions
MSTR Desktop
36. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Components of Compound Metrics
Thresholding
Reports
The 3 MSTR Tools
37. Used for - Initially populating the Metadata - Creating schema objects
Warehouse Catalog
MSTR Desktop Architect
Report Formatting
Architect Graphical Interface
38. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
5 steps to creating a logical data model
Homogeneous Fact
Attribute Forms
The 3 MSTR Tools
39. A development environment to create BI applications - allowing users to edit the Metadata database
Application Objects
Long-term (2 - 5 years)
Filter Definition Prompts
Desktop Architec
40. Metrics you create within a report using only those objects in the report.
2 components of a Physical Schema
Derived Metrics
4 properties you must know in order to create attributes using the Attribute Editor
Fact Tables
41. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
By default
Using a Search Object
Attribute Relationships
Limitations of the Attribute Creation Wizard
42. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
MSTR OLAP Services
4 types of Report Filters
Types of analysis you can perform with OLAP Services
Compound Metric
43. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
To "drill down" on a report
Long-term (2 - 5 years)
Limitations of the Attribute Creation Wizard
The 3 MSTR Tools
44. Simple - Compound - Nested - Derived
4 types of Metrics
Report Template
Desktop Architec
Characteristics of a Simple Table Key
45. Specifies a condition data must meet in order to be included in a report
Report Filter
Drilling
Data warehouse characteristics
Attribute Forms
46. What tool do you use to create the Metadata shell?
Shortcut in MSTR Desktop
Configuration Wizard
Desktop Analyst
To drill through User Hierarchies
47. It contains the ID column of all higher-level attributes
To drill through User Hierarchies
Table Keys
Characteristics of a Simple Table Key
Lookup Table structure of a moderately denormalized schema
48. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Desktop Designer
Process for creating the Project Metadata
Heterogeneous Fact
Metrics
49. The logical associations between attributes that exist based on a business rule
Configuration Wizard
Attribute Relationships
MSTR Desktop
ID form
50. To define the level of aggregation for a specific metric - Used for qualifications
Shortcut Bar
2 types of Attribute Relationships
3 Types of Objects in MSTR Desktop
Attributes