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. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
2 types of Table Keys
Cannot create project objects
Simple Attribute Expression
Source system characteristics
2. Using the Prompt Generation Wizard - Inside the Report Editor
4 tasks of the Attribute Creation Wizard
ETL process
To create a Report Prompt
2 types of Attribute Expression
3. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Hierarchies
2 types of Fact Expressions
Fact Tables
Facts
4. How users can share comments for reports to other users
Report Subscription
Notes
Types of drilling
2-Tier Architecture
5. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Attribute Forms
Unlimited
Stored
ETL
6. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Tasks when defining a User Hierarchy
Types of analysis you can perform with OLAP Services
Project Source
To create a Report Prompt
7. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Hierarchies
The 3 MSTR Tools
Page-by
2 types of Attribute Relationships
8. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
Attributes
ETL process
'View of a Report'
9. Top menu/dropdowns - Toolbar - Right-click popup menus
3 Methods of MSTR Desktop navigation
Logical Data Model
Report Editor
Data Pivoting
10. You can _____________ in the Architect Graphical Interface.
Short-term (2 - 6 months)
Report Template
Heterogeneous Attribute
Rollback your changes
11. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
3 Types of Objects in MSTR Desktop
Very high; part of ETL process
3 components of a Report
12. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
Cannot create project objects
5 Report display views
4 tasks of the Attribute Creation Wizard
Lookup Tables
13. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
2 types of Table Keys
Simple Metrics
Attribute Elements
Locking and Resizing
14. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
4 factors to consider when designing a data-warehouse schema
Shortcut Bar
3 Schema types
15. Metrics you create within a report using only those objects in the report.
Derived Metrics
Value Prompts
To "drill down" on a report
Minimal or none
16. All Attributes must have an _______.
MSTR OLAP Services
Types of drilling
ID form
New SQL
17. A feature that enables users to delivers reports to the history list - cache or mobile
Configuration Wizard
Project Creation Wizard
Heterogeneous Attribute
Report Subscription
18. Facts associated to different column names in 2 or more tables
MSTR OLAP Services
Heterogeneous Fact
Limitations of the Attribute Creation Wizard
Objects you are allowed to Page-by
19. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending
2-Tier Architecture
Notes
Characteristics of Nested Metrics
Sorting
20. Used to limit a possibly overwhelming set of potential prompt answers
Value Prompts
Search-based prompts
MSTR Desktop
Warehouse Catalog
21. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Drilling
Components of Compound Metrics
MSTR Connectivity Wizard
Facts
22. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
4 types of Prompts
3 Methods of MSTR Desktop navigation
Table Keys
Schema
23. What tool do you use to create the Metadata DSN connection?
Attribute or its relationship(s)
Report Filter
MSTR Connectivity Wizard
Shortcut in MSTR Desktop
24. You can e-mail reports by going to _____
Desktop Administrative Functions
To create a Report Prompt
File > Email Reports As
Project
25. Facts - Attributes - Hierarchies
Filter Definition Prompts
Components of the Logical Data Model
Data Pivoting
Components of Compound Metrics
26. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Page-by
Shortcut Bar
Desktop Analyst
Application Objects
27. Metrics that perform multiple aggregations; one calculation inside of another.
Facts
Nested Metrics
Warehouse Catalog
ETL
28. 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.
View Filters
3 column types of a Physical Schema
Configuration Wizard
Nested Metrics
29. Schema Objects - Application Objects - Configuration Objects
The 3 MSTR Tools
2 ways you can configure the Project Source to connect to the Metadata database
Highest-level attributes
3 Types of Objects in MSTR Desktop
30. It contains links to specific folders in the Folder List
Shortcut Bar
Outline Mode
4 tasks of the Attribute Creation Wizard
3 Methods of MSTR Desktop navigation
31. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
By default
Characteristics of Nested Metrics
Fact Expression
Cannot create project objects
32. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Attribute Forms
Nested Metrics
Types of analysis you can perform with OLAP Services
Facts
33. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Outline Mode
2 types of Table Keys
Cannot create project objects
Project Source
34. Descriptive data that provides context for Facts.
Aggregate a Metric
Shortcut in MSTR Desktop
Fact Expression
Attribute Forms
35. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Types of drilling
Report Filter operators
3-Tier Architecture
Components of the Logical Data Model
36. OLAP data storage measure
Object Prompts
Report Filter
To "drill down" on a report
Terabytes (TB)
37. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Using a Search Object
2 types of Attribute Relationships
Metrics
MSTR applications
38. Facts associated to the same column name in 1 or more tables
Homogeneous Fact
Very high; part of ETL process
OLAP
To create the Project connectivity
39. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Level Prompts
Application Objects
Nested Metrics
Homogeneous Fact
40. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
By default
2 types of Table Keys
Column Aliases
4 tasks of the Attribute Creation Wizard
41. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
User Hierarchies
ETL process
Attributes
2 types of Attribute Expression
42. User requirements - Existing source data - Technical and performance considerations
Report Filter
Search Object
Factors to consider when designing a logical data model
Attributes
43. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Unlimited
Process for creating the Project Metadata
Metrics
View Filters
44. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Attribute Forms
Report Filter
Report Subscription
Search Object
45. 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.
Table Keys
ETL process
Attribute or its relationship(s)
Report Prompts
46. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Components of the Logical Data Model
Attribute or its relationship(s)
4 properties you must know in order to create attributes using the Attribute Editor
Fact Tables
47. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Thresholding
MSTR applications
Table Keys
2 types of Attribute Relationships
48. OLTP data storage measure
Limitations of the Attribute Creation Wizard
Gigabytes (GB)
2 methods to creating Facts
Aggregate a Metric
49. The Attribute Form Expression that maps to a single column - no matter the number of tables
File types are allowed for exporting a Report
Simple Attribute Expression
Attributes
Report Filter
50. Attribute Creation Wizard - Attribute Editor
Desktop Architec
Methods are there to creating Attributes
Relationship Tables
Architect Graphical Interface