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. Filter definition prompts - Object prompts - Value prompts - Level prompts
Sorting
Column Aliases
4 types of Prompts
3 project creation interfaces
2. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Facts
Warehouse Catalog
4 parts of the Project Design Process
Components of a Metric
3. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
Physical Schema
OLTP
4 basic Schema objects
Drilling
4. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
OLTP
Project-level options/settings
Process for creating the Project Metadata
Gigabytes (GB)
5. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Types of drilling
Schema
To "drill down" on a report
Factors to consider when designing a logical data model
6. Metrics you create within a report using only those objects in the report.
File types are allowed for exporting a Report
Report Filter
Derived Metrics
Attribute Elements
7. It contains the ID and DESC columns of all higher-level attributes
To drill through User Hierarchies
Lookup Table structure of a completely denormalized schema
Filter Definition Prompts
Search-based prompts
8. OLTP data storage measure
Report Filter
Components of a Derived Metric
Gigabytes (GB)
Shortcut in MSTR Desktop
9. Simple - Compound - Nested - Derived
Locking and Resizing
4 types of Metrics
Lookup Table structure of a completely denormalized schema
Nested Metrics
10. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
2 methods to creating Facts
Simple Metrics
Nested Metrics
3-Tier Architecture
11. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
File > Email Reports As
Simple Metrics
MSTR OLAP Services
12. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Subtotals
View Filter
Attribute Creation Wizard good for
3 functions of Attribute Forms
13. A feature that enables users to delivers reports to the history list - cache or mobile
Schema
Simple Metrics
Relationship Tables
Report Subscription
14. AND - OR - OR NOT - AND NOT
Report Filter operators
Default Project folder structure
Required on the report for Outline Model to work
Report Filter
15. The default entry-points.
Metrics
Facts
Highest-level attributes
Sample Metrics commonly performed on Facts
16. A user interface for creating and maintaining a BI environment
5 Report display views
Table Keys
MSTR Desktop
Objects you are allowed to Page-by
17. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications
Components of the Logical Data Model
Data warehouse characteristics
MSTR Desktop
Components of a MSTR architecture
18. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Different methods for creating Page-by fields
ETL process
Table Keys
Unlimited
19. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
Filter Definition Prompts
Schema Objects
Compound Metric
20. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Simple Metrics
Methods are there to creating Attributes
Very high; part of ETL process
21. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Project-level options/settings
Level Prompts
4 types of Prompts
Terabytes (TB)
22. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Terabytes (TB)
2 types of Table Keys
5 Report display views
To create the Project connectivity
23. It contains the ID column of the parent attribute
Lookup Table structure of a completely normalized schema
4 types of Prompts
3 Methods of MSTR Desktop navigation
Sample Metrics commonly performed on Facts
24. Creating multiple attributes quickly. Used during the initial project creation.
Attribute Creation Wizard good for
Fact Expression
Attribute Forms
Default Project folder structure
25. It contains links to specific folders in the Folder List
Shortcut Bar
Object Prompts
New SQL
Attribute Relationships
26. Store info about attributes - including IDs and any descriptions. Used for easier browsing.
Components of the Logical Data Model
Heterogeneous Fact
ETL
Lookup Tables
27. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Outline Mode
2 components of a Physical Schema
Default Project folder structure
28. Used to "fine-tune" your Project
To "drill down" on a report
Reports
Architect Graphical Interface
2 types of Attribute Relationships
29. A shortcut to an existing Object in a Project
3 functions of Attribute Forms
Project
Shortcut in MSTR Desktop
ETL process
30. Schema Objects - Application Objects - Configuration Objects
3 types of Attributes
Process for creating the Project Metadata
2 types of Facts
3 Types of Objects in MSTR Desktop
31. Used to modify a Report
Report Editor
Nested Metrics
Components of a MSTR architecture
The System
32. You must select "Other directions" when drilling attributes while viewing a report
2 components of a Physical Schema
Report Subscription
To drill through User Hierarchies
Subtotals
33. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Project Creation Wizard
Components of a Metric
Desktop Administrative Functions
Schema Objects
34. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Physical Schema
2 ways you can configure the Project Source to connect to the Metadata database
4 tasks of the Attribute Creation Wizard
Configuration Wizard
35. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Components of a Derived Metric
Characteristics of Nested Metrics
Compound Metric
Report Editor
36. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Project
MSTR OLAP Services
Attribute Forms
4 types of Report Filters
37. OLTP retains data ________
Short-term (2 - 6 months)
To create the Project connectivity
Attribute Forms
Project Source
38. Groupings of directly related attributes. Also commonly known as "dimensions".
Heterogeneous Attribute
To "drill down" on a report
Facts
Hierarchies
39. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Shortcut in MSTR Desktop
OLTP
Stored
File types are allowed for exporting a Report
40. Less storage - Simple SQL - Complex ETL
Facts
Methods are there to creating Attributes
Characteristics of a Simple Table Key
Derived Metrics
41. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Tasks when defining a User Hierarchy
Locking and Resizing
4 properties you must know in order to create attributes using the Attribute Editor
Factors to consider when designing a logical data model
42. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
To edit the appearance of a Graph in a report
MSTR applications
Shortcut Bar
43. Attribute Creation Wizard - Attribute Editor
3 Types of Objects in MSTR Desktop
Methods are there to creating Attributes
2 ways you can configure the Project Source to connect to the Metadata database
Nested Metrics
44. OLAP Services does not add any ______ to the report query.
Physical Schema
Architect Graphical Interface
New SQL
Object Prompts
45. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Methods are there to creating Attributes
Filter Definition Prompts
Level Prompts
Attribute Relationships
46. OLAP retains data ________
Notes
Process for creating the Project Metadata
Long-term (2 - 5 years)
Sample Metrics commonly performed on Facts
47. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Heterogeneous Fact
Project-level options/settings
Schema Objects
Source system characteristics
48. An environment in which the MSTR Desktop connects directly to the Metadata database.
2-Tier Architecture
Hierarchies
Locking and Resizing
Logical Data Model
49. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
Object Prompts
Homogeneous Attribute
4 types of Prompts
Required on the report for Outline Model to work
50. It contains the ID column of all higher-level attributes
5 steps to creating a logical data model
To save a Report Format
3 Sections of the MSTR Desktop interface
Lookup Table structure of a moderately denormalized schema