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.
Column Aliases
User Hierarchies
Methods are there to creating Attributes
Thresholding
2. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
ETL
Limitations of the Attribute Creation Wizard
Aggregate a Metric
3 Sections of the MSTR Desktop interface
3. It contains the ID and DESC columns of all higher-level attributes
Attribute Creation Wizard good for
Reports
Project Source
Lookup Table structure of a completely denormalized schema
4. Used for - Initially populating the Metadata - Creating schema objects
Drilling
MSTR Desktop Architect
User Hierarchies
Banding
5. View Filters can only ___________.
Default Project folder structure
Short-term (2 - 6 months)
Reference Report Objects
Report Editor
6. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Report Prompts
Facts
Architect Graphical Interface
Components of Compound Metrics
7. Prompts to select a single value on which to qualify a date - number or text string.
To create the Project connectivity
Value Prompts
Desktop Designer
Drilling
8. Groupings of directly related attributes. Also commonly known as "dimensions".
View Filter
Components of the Logical Data Model
Heterogeneous Fact
Hierarchies
9. OLTP data storage measure
Minimal or none
Derived Attribute Expression
Gigabytes (GB)
ETL
10. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
Report Editor
Logical Data Model
Report Subscription
Metrics
11. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Thresholding
'View of a Report'
Aggregate a Metric
2 options for Sorting
12. OLAP Services does not add any ______ to the report query.
Simple Attribute Expression
Attributes
Attribute Forms
New SQL
13. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
ETL process
Outline Mode
Schema
3 Schema types
14. Columns - Tables
2 components of a Physical Schema
2 types of Attribute Expression
Level Prompts
Report Definitions
15. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
To create the Project connectivity
The 3 MSTR Tools
Project Creation Wizard
Desktop Designer
16. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Hierarchies
3 functions of Attribute Forms
4 parts of the Project Design Process
OLAP
17. ID columns - Description columns - Fact columns
To create a Report Prompt
Value Prompts
MSTR Desktop
3 column types of a Physical Schema
18. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
2 ways you can configure the Project Source to connect to the Metadata database
Default Project folder structure
Terabytes (TB)
Physical Schema
19. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
Sorting
Minimal or none
Aggregate a Metric
Search-based prompts
20. How users can share comments for reports to other users
Project Source
2 types of Fact Expressions
Notes
Lookup Tables
21. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Characteristics of Nested Metrics
Object Prompts
Schema Objects
Drilling
22. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
5 Report display views
Components of a Derived Metric
Compound Attribute
Using a Search Object
23. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface
Lookup Table structure of a completely denormalized schema
Sample Metrics commonly performed on Facts
Advantage of a completely denormalized schema
3 project creation interfaces
24. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Search Object
3 Methods of MSTR Desktop navigation
Simple Attribute Expression
Desktop Administrative Functions
25. A shortcut to an existing Object in a Project
3 column types of a Physical Schema
Logical Data Model
Project-level options/settings
Shortcut in MSTR Desktop
26. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Components of Compound Metrics
3 column types of a Physical Schema
Data warehouse characteristics
Lookup Tables
27. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Derived Attribute Expression
Compound Metric
3 Methods of MSTR Desktop navigation
Search Object
28. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Display views you can Print by
5 steps to creating a logical data model
2 ways you can configure the Project Source to connect to the Metadata database
Different methods for creating Page-by fields
29. OLTP retains data ________
Short-term (2 - 6 months)
Lookup Table structure of a moderately denormalized schema
Default Project folder structure
Level Prompts
30. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
3 Schema types
3 types of Attributes
Attribute or its relationship(s)
Methods are there to creating Attributes
31. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Outline Mode
To create the Project connectivity
Application Objects
Attributes
32. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
3 functions of Attribute Forms
Column Aliases
2 types of Attribute Relationships
Characteristics of a Compound Table Key
33. OLAP data storage measure
Terabytes (TB)
2-Tier Architecture
Using a Search Object
Search Object
34. Allow you to interact with the BI system - logically organize data to analyze complex relationships
File types are allowed for exporting a Report
Types of drilling
MSTR applications
Level Prompts
35. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Locking and Resizing
File types are allowed for exporting a Report
New SQL
To drill through User Hierarchies
36. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Default Project folder structure
Data warehouse characteristics
Outline Mode
3 project creation interfaces
37. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Shortcut Bar
To save a Report Format
Hierarchies
Report Objects
38. Metrics aggregate on the lowest-level attribute __________.
3 project creation interfaces
Logical Data Model
Components of a MSTR architecture
By default
39. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
40. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
OLTP
4 parts of the Project Design Process
View Filter
Reference Report Objects
41. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
To edit the appearance of a Graph in a report
OLTP
4 properties you must know in order to create attributes using the Attribute Editor
3 functions of Attribute Forms
42. Metrics that perform multiple aggregations; one calculation inside of another.
The 3 MSTR Tools
Nested Metrics
Data warehouse characteristics
4 parts of the Project Design Process
43. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Hierarchies
By default
Limitations of the Attribute Creation Wizard
Fact Expression
44. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Desktop Administrative Functions
Project Source
Column Aliases
Derived Attribute Expression
45. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Fact Tables
Desktop Analyst
The System
Derived Metrics
46. Primary keys
Homogeneous Fact
Table Keys
Filter Definition Prompts
Default Project folder structure
47. Less storage - Simple SQL - Complex ETL
Level Prompts
Characteristics of a Simple Table Key
Terabytes (TB)
2-Tier Architecture
48. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Warehouse Catalog
Components of a Metric
2 types of Fact Expressions
49. To define the level of aggregation for a specific metric - Used for qualifications
Required on the report for Outline Model to work
Attributes
File > Email Reports As
Components of the Logical Data Model
50. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
Types of drilling
Nested Metrics
2 types of Facts
Report Filter operators