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. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Thresholding
View Filter
Project-level options/settings
Long-term (2 - 5 years)
2. The Attribute Form maps to different column names in multiple tables
Filter Definition Prompts
Heterogeneous Attribute
4 types of Metrics
View Filters
3. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Types of drilling
User Hierarchies
5 Report display views
4. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
2 types of Fact Expressions
Cannot create project objects
Report Filter
Filter Definition Prompts
5. Formula - Level (Dimensionality) - Conditionality - Transformation
Display views you can Print by
Source system characteristics
Components of a Metric
Logical Data Model
6. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
4 properties you must know in order to create attributes using the Attribute Editor
ETL process
Reports
Report Filter
7. 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
4 parts of the Project Design Process
Very high; part of ETL process
MSTR OLAP Services
8. Used to "fine-tune" your Project
Gigabytes (GB)
The 3 MSTR Tools
Architect Graphical Interface
New SQL
9. It contains the ID and DESC columns of all higher-level attributes
Level Prompts
Types of drilling
Lookup Table structure of a completely denormalized schema
Data warehouse characteristics
10. The logical associations between attributes that exist based on a business rule
Attribute Relationships
MSTR OLAP Services
Components of a MSTR architecture
Object Prompts
11. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
Using a Search Object
Components of the Logical Data Model
To save a Report Format
12. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
Characteristics of a Simple Table Key
Data warehouse characteristics
Rollback your changes
13. The Attribute Form maps to the same column name in multiple tables
Components of a Metric
Derived Metrics
Attribute Relationships
Homogeneous Attribute
14. OLAP Services does not add any ______ to the report query.
4 factors to consider when designing a data-warehouse schema
Value Prompts
Schema Object Editor
New SQL
15. What tool do you use to create the Metadata shell?
Attribute Creation Wizard good for
Relationship Tables
Different methods for creating Page-by fields
Configuration Wizard
16. Used for - Initially populating the Metadata - Creating schema objects
Tasks when defining a User Hierarchy
MSTR Desktop Architect
Schema Objects
Object Prompts
17. OLTP data storage measure
Report Filter operators
To save a Report Format
Very high; part of ETL process
Gigabytes (GB)
18. OLAP retains data ________
Long-term (2 - 5 years)
Characteristics of Nested Metrics
Relationship Tables
Report Objects
19. Schema Objects - Application Objects - Configuration Objects
3 components of a Report
3 Types of Objects in MSTR Desktop
Desktop Designer
MSTR Connectivity Wizard
20. You can _____________ in the Architect Graphical Interface.
Rollback your changes
ID form
Report Formatting
OLTP
21. Top menu/dropdowns - Toolbar - Right-click popup menus
Attribute Creation Wizard good for
To create the Project connectivity
3 Methods of MSTR Desktop navigation
To create a Report Prompt
22. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Source system characteristics
Factors to consider when designing a logical data model
Attribute Elements
4 tasks of the Attribute Creation Wizard
23. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Schema Objects
3 types of Attributes
Terabytes (TB)
24. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
Rollback your changes
Long-term (2 - 5 years)
Factors to consider when designing a logical data model
ETL process
25. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
ID form
Simple Metrics
Types of drilling
26. 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
Required on the report for Outline Model to work
Tasks when defining a User Hierarchy
2 types of Attribute Expression
Project
27. You can e-mail reports by going to _____
Facts
Attribute or its relationship(s)
File > Email Reports As
Different methods for creating Page-by fields
28. Columns - Tables
File > Email Reports As
2 components of a Physical Schema
3 functions of Attribute Forms
To "drill down" on a report
29. Homogeneous - Heterogeneous
File > Email Reports As
2 types of Facts
OLTP
Facts
30. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
5 steps to creating a logical data model
Gigabytes (GB)
Short-term (2 - 6 months)
4 properties you must know in order to create attributes using the Attribute Editor
31. Less storage - Simple SQL - Complex ETL
Characteristics of a Simple Table Key
Search-based prompts
Report Filter
Outline Mode
32. Prompts to select a single value on which to qualify a date - number or text string.
Value Prompts
Objects you are allowed to Page-by
Lookup Table structure of a moderately denormalized schema
2 types of Facts
33. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Report Filter
Subtotals
Thresholding
Characteristics of Nested Metrics
34. More storage - Complex SQL - Simple ETL
Hierarchies
Compound Metric
Reference Report Objects
Characteristics of a Compound Table Key
35. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Minimal or none
Stored
Search Object
Required on the report for Outline Model to work
36. To define the level of aggregation for a specific metric - Used for qualifications
Using a Search Object
Attributes
The System
To drill through User Hierarchies
37. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Gigabytes (GB)
Objects you are allowed to Page-by
Relationship Tables
Derived Attribute Expression
38. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Notes
4 tasks of the Attribute Creation Wizard
3 Methods of MSTR Desktop navigation
Report Editor
39. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
2 types of Attribute Relationships
Metrics
File types are allowed for exporting a Report
Characteristics of a Simple Table Key
40. Create the Project Source - Create the Database Instance
Desktop Analyst
To create the Project connectivity
3 column types of a Physical Schema
3-Tier Architecture
41. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
Notes
2 types of Table Keys
Cannot create project objects
Tasks when defining a User Hierarchy
42. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
Facts
Source system characteristics
By default
43. Reduced number of JOINS in the generated SQL
Methods are there to creating Attributes
Advantage of a completely denormalized schema
To qualify a Metric in a Set Qualification
Characteristics of Nested Metrics
44. Enables you to search for a specific Object or group of Objects that meet a certain criteria.
Simple Attribute Expression
Hierarchies
Search Object
Notes
45. To see data at completely different levels - other than that of the original Grid or Graph
Report Editor
Source system characteristics
Drilling
5 steps to creating a logical data model
46. Allow you to interact with the BI system - logically organize data to analyze complex relationships
3 Schema types
Fact Expression
Locking and Resizing
MSTR applications
47. 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
Characteristics of a Simple Table Key
3 Schema types
Cannot create project objects
User Hierarchies
48. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Short-term (2 - 6 months)
Attribute or its relationship(s)
Hierarchies
Desktop Designer
49. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Required on the report for Outline Model to work
Process for creating the Project Metadata
2 options for Sorting
Source system characteristics
50. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
View Filters
Attribute or its relationship(s)
Schema
Report Formatting
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests