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. Tables - Facts - Attributes - Hierarchies
Logical Data Model
4 basic Schema objects
Report Filter
New SQL
2. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
To create the Project connectivity
Simple Metrics
Shortcut Bar
Objects you are allowed to Page-by
3. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Drilling
Facts
Desktop Administrative Functions
Components of a Metric
4. Create the Project Source - Create the Database Instance
Types of analysis you can perform with OLAP Services
Different methods for creating Page-by fields
Facts
To create the Project connectivity
5. 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
Desktop Designer
Advantage of a completely denormalized schema
Logical Data Model
Heterogeneous Fact
6. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Short-term (2 - 6 months)
Desktop Designer
5 Report display views
3 functions of Attribute Forms
7. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Desktop Analyst
Nested Metrics
To save a Report Format
Search-based prompts
8. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
3 column types of a Physical Schema
ETL process
Desktop Designer
Heterogeneous Attribute
9. Used to "fine-tune" your Project
Rollback your changes
Lookup Table structure of a moderately denormalized schema
Architect Graphical Interface
MSTR Desktop
10. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
Project-level options/settings
Report Objects
2 methods to creating Facts
Components of a Metric
11. An environment in which the MSTR Desktop connects directly to the Metadata database.
4 types of Report Filters
Highest-level attributes
Column Aliases
2-Tier Architecture
12. OLAP Services does not add any ______ to the report query.
New SQL
Fact Tables
2 methods to creating Facts
3 column types of a Physical Schema
13. The Attribute Form maps to different column names in multiple tables
Table Keys
Heterogeneous Attribute
Report Filter operators
Attribute Creation Wizard good for
14. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
2 types of Attribute Expression
Project Source
Level Prompts
Schema
15. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
3 Sections of the MSTR Desktop interface
Desktop Analyst
Lookup Tables
Project-level options/settings
16. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Aggregate a Metric
2 ways you can configure the Project Source to connect to the Metadata database
2-Tier Architecture
5 steps to creating a logical data model
17. Formula - Level (Dimensionality) - Conditionality - Transformation
File > Email Reports As
Components of a Metric
By default
To "drill down" on a report
18. Facts associated to different column names in 2 or more tables
4 types of Report Filters
Schema Objects
Heterogeneous Fact
4 parts of the Project Design Process
19. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Tasks when defining a User Hierarchy
Attributes
3 types of Attributes
Aggregate a Metric
20. More storage - Complex SQL - Simple ETL
Report Definitions
Methods are there to creating Attributes
Project-level options/settings
Characteristics of a Compound Table Key
21. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
To save a Report Format
Drilling
MSTR OLAP Services
Simple Attribute Expression
22. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Architect Graphical Interface
Lookup Tables
3 Schema types
23. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
2 types of Facts
Column Aliases
Filter Definition Prompts
OLTP
24. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Limitations of the Attribute Creation Wizard
Desktop Administrative Functions
To "drill down" on a report
Long-term (2 - 5 years)
25. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Column Aliases
Schema Objects
Desktop Architec
File > Email Reports As
26. You can e-mail reports by going to _____
Logical Data Model
File > Email Reports As
3 column types of a Physical Schema
Report Definitions
27. 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
Components of a MSTR architecture
Architect Graphical Interface
Homogeneous Attribute
28. Specifies what info to retrieve from a data-warehouse - and how to display it
Object Prompts
2 types of Table Keys
Characteristics of a Compound Table Key
Report Template
29. Enables you to select which tables from the data-warehouse to store in the Metadata database
MSTR Connectivity Wizard
The 3 MSTR Tools
Warehouse Catalog
Facts
30. User requirements - Existing source data - Technical and performance considerations
Facts
Factors to consider when designing a logical data model
Report Objects
Objects you are allowed to Page-by
31. 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.
Project Creation Wizard
View Filters
Report Filter
Data warehouse characteristics
32. To see data at completely different levels - other than that of the original Grid or Graph
Drilling
Limitations of the Attribute Creation Wizard
Types of analysis you can perform with OLAP Services
Simple Attribute Expression
33. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
3-Tier Architecture
2 types of Attribute Relationships
Cannot create project objects
Compound Metric
34. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Architect Graphical Interface
Advantage of a completely denormalized schema
Banding
File types are allowed for exporting a Report
35. Enables you to lock column headers so that they always appear when scrolling
3-Tier Architecture
Attribute Forms
3 Sections of the MSTR Desktop interface
Locking and Resizing
36. Level of OLTP integration
Derived Attribute Expression
Methods are there to creating Attributes
Minimal or none
Schema
37. OLAP retains data ________
2 types of Table Keys
Long-term (2 - 5 years)
Components of a Metric
5 steps to creating a logical data model
38. What tool do you use to create the Metadata shell?
Short-term (2 - 6 months)
3 Sections of the MSTR Desktop interface
Configuration Wizard
2 types of Facts
39. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Limitations of the Attribute Creation Wizard
Heterogeneous Fact
Search Object
40. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
Types of analysis you can perform with OLAP Services
Using a Search Object
Value Prompts
41. Primary keys
Derived Metrics
Table Keys
Unlimited
5 Report display views
42. A development environment to create BI applications - allowing users to edit the Metadata database
Sample Metrics commonly performed on Facts
2 types of Attribute Expression
Objects you are allowed to Page-by
Desktop Architec
43. A shortcut to an existing Object in a Project
Characteristics of a Compound Table Key
3 project creation interfaces
Shortcut in MSTR Desktop
Attribute Creation Wizard good for
44. Less storage - Simple SQL - Complex ETL
Schema Objects
Characteristics of a Simple Table Key
To create the Project connectivity
To edit the appearance of a Graph in a report
45. Columns - Tables
Report Subscription
Display views you can Print by
Components of a MSTR architecture
2 components of a Physical Schema
46. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Homogeneous Fact
Types of analysis you can perform with OLAP Services
Desktop Designer
2 methods to creating Facts
47. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Sorting
2 components of a Physical Schema
To edit the appearance of a Graph in a report
Report Prompts
48. How users can share comments for reports to other users
Notes
4 factors to consider when designing a data-warehouse schema
'View of a Report'
Locking and Resizing
49. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Report Template
3 Sections of the MSTR Desktop interface
OLAP
File > Email Reports As
50. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Architect Graphical Interface
Filter Definition Prompts
Notes
Column Aliases
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