Test your basic knowledge |

Certified Project Designer Cpd

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. It contains the ID column of the parent attribute
Advantage of a completely denormalized schema
Characteristics of a Simple Table Key
Lookup Table structure of a completely normalized schema
Report Filter

2. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
5 Report display views
4 types of Prompts
Long-term (2 - 5 years)

3. User requirements - Existing source data - Technical and performance considerations
Cannot create project objects
2 types of Fact Expressions
Locking and Resizing
Factors to consider when designing a logical data model

4. A development environment to create BI applications - allowing users to edit the Metadata database
Sample Metrics commonly performed on Facts
MSTR Desktop
Desktop Architec
Project

5. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
2 types of Attribute Relationships
MSTR applications
The System

6. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
Warehouse Catalog
Facts
Attributes
Fact Tables

7. Enables you to select and display subsets of a report as separate pages.
Using a Search Object
Page-by
Long-term (2 - 5 years)
3 Methods of MSTR Desktop navigation

8. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression
4 parts of the Project Design Process
Compound Metric
2 types of Fact Expressions
The System

9. Folder List - Object Viewer - Shortcut Bar
3 Sections of the MSTR Desktop interface
OLTP
Cannot create project objects
Sample Metrics commonly performed on Facts

10. OLAP Services does not add any ______ to the report query.
3 types of Attributes
2 types of Fact Expressions
New SQL
Required on the report for Outline Model to work

11. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Cannot create project objects
3-Tier Architecture
Attribute Relationships
Desktop Analyst

12. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Required on the report for Outline Model to work
Project-level options/settings
3 Schema types
Shortcut Bar

13. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Application Objects
Display views you can Print by
Simple Metrics
Default Project folder structure

14. Enables you to select which tables from the data-warehouse to store in the Metadata database
Warehouse Catalog
Desktop Designer
3 components of a Report
File > Email Reports As

15. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
Derived Metrics
5 steps to creating a logical data model
Components of a Derived Metric
OLTP

16. The Attribute Form Expression that maps to a single column - no matter the number of tables
To create a Report Prompt
Simple Attribute Expression
To save a Report Format
2 types of Attribute Expression

17. Extraction - transformation - loading
Lookup Tables
ETL
Logical Data Model
Default Project folder structure

18. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
View Filter
Objects you are allowed to Page-by
Sample Metrics commonly performed on Facts
Derived Metrics

19. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Heterogeneous Fact
By default
ETL process
Reports

20. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Fact Tables
Warehouse Catalog
Types of drilling
Project Creation Wizard

21. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Process for creating the Project Metadata
4 properties you must know in order to create attributes using the Attribute Editor
Attribute Forms
Schema

22. Facts - Attributes - Hierarchies
3 Sections of the MSTR Desktop interface
Compound Metric
Configuration Wizard
Components of the Logical Data Model

23. A feature that enables users to delivers reports to the history list - cache or mobile
Stored
Tasks when defining a User Hierarchy
Thresholding
Report Subscription

24. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Subscription
Report Prompts
Report Filter
Project Source

25. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Facts
Unlimited
Page-by
Desktop Architec

26. Descriptive data that provides context for Facts.
2 ways you can configure the Project Source to connect to the Metadata database
To create the Project connectivity
Characteristics of a Simple Table Key
Attribute Forms

27. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Limitations of the Attribute Creation Wizard
Attribute Elements
Report Editor
OLAP

28. More storage - Complex SQL - Simple ETL
Factors to consider when designing a logical data model
3 functions of Attribute Forms
Characteristics of a Compound Table Key
Data Pivoting

29. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
4 parts of the Project Design Process
Data warehouse characteristics
Aggregate a Metric
Facts

30. OLTP retains data ________
Filter Definition Prompts
Short-term (2 - 6 months)
Relationship Tables
Object Prompts

31. 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

32. Simple - Derived
2 types of Attribute Expression
Architect Graphical Interface
Types of analysis you can perform with OLAP Services
Fact Expression

33. An environment in which the MSTR Desktop connects directly to the Metadata database.
Subtotals
2-Tier Architecture
Very high; part of ETL process
Project

34. OLTP data storage measure
Gigabytes (GB)
Report Prompts
Report Template
Fact Tables

35. Direct: 2-tier - Server: 3-tier
Fact Expression
Unlimited
2 ways you can configure the Project Source to connect to the Metadata database
Components of Compound Metrics

36. Template - Filter - View of a Report
Relationship Tables
Types of analysis you can perform with OLAP Services
2 components of a Physical Schema
3 components of a Report

37. Must have a one-to-one relationship with all other forms.
Report Filter operators
Attribute Forms
MSTR Desktop Architect
Lookup Tables

38. Used to modify a Report
4 parts of the Project Design Process
Heterogeneous Fact
Report Editor
OLAP

39. How users can share comments for reports to other users
3 Methods of MSTR Desktop navigation
Notes
3 functions of Attribute Forms
Minimal or none

40. To define the level of aggregation for a specific metric - Used for qualifications
Using a Search Object
Attributes
OLAP
Attribute Relationships

41. OLAP retains data ________
Attribute or its relationship(s)
To create a Report Prompt
Report Template
Long-term (2 - 5 years)

42. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Lookup Table structure of a moderately denormalized schema
Types of analysis you can perform with OLAP Services
Data warehouse characteristics
3 Types of Objects in MSTR Desktop

43. Columns - Tables
Column Aliases
Cannot create project objects
2 components of a Physical Schema
Project Source

44. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Relationship Tables
Minimal or none
To qualify a Metric in a Set Qualification
4 properties you must know in order to create attributes using the Attribute Editor

45. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Derived Attribute Expression
Outline Mode
4 properties you must know in order to create attributes using the Attribute Editor

46. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
2 components of a Physical Schema
MSTR applications
Attribute Forms

47. Prompts to select a single value on which to qualify a date - number or text string.
Homogeneous Attribute
Attribute Relationships
Configuration Wizard
Value Prompts

48. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.
5 Report display views
Attribute Relationships
Using a Search Object
Physical Schema

49. 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
Architect Graphical Interface
Characteristics of Nested Metrics
Report Template
Reference Report Objects

50. Used to "fine-tune" your Project
Architect Graphical Interface
Table Keys
2 types of Fact Expressions
Hierarchies