GMetrix Data Modeling Practice Test

These questions are part of the practice quiz. Start practicing

• The ______________ function extracts the middle characters from a block of text.
• When is denormalization typically used, and what is a common trade-off?
• Which tab contains the Show Formulas command?
• To create a table from data, which tab contains the Tables group?
• Which term describes the text to accompany charts for accessibility?
• The __________________ function looks up data, sorts it, then uses it to generate a list in a new location.
• What are mini-charts that represent data visually without taking up much space on a worksheet?
• Which statement best describes a functional dependency X -> Y?
• To revert a cell's appearance to default while preserving its value, you would choose which option?
• Which tool is used to quickly copy formatting from one cell to another without copying the cell's contents?
• What is normalization's impact on update anomalies?
• What is a surrogate key, and why might it be used instead of a natural key?
• Dimensional modeling uses surrogate keys mainly to achieve what?
• Named _______ provide an easy way to locate important parts of a workbook.
• Denormalization refers to introducing redundancy intentionally to improve performance.
• What describes the primary difference among conceptual, logical, and physical data models?
• What is a bridging table and when is it used?
• Where can you find the Convert to Range option to turn a table back into a range?
• Adding properties to a file adds which of the following to facilitate search?
• Which operation converts a vertical range to a horizontal range during paste?
• To reset a cell's formatting to its default state without deleting the data, you would choose which option?
• What is a materialized view and how does it relate to denormalization?
• In Excel, the content of the active cell, including its formula when applicable, is shown in which bar?
• When a Total Row is added to a table, where does it appear and what does it sum by default?
• The Quick Access Toolbar holds basic, frequently used ________ in one place.
• In the typical progression, what step follows mapping to tables and columns?
• How do you map a many-to-many relationship to a relational schema?
• Users can adjust Row Height and Column Width using the ___________ dropdown menu in the Cells group on the Home tab
• Define conformed dimensions.
• Within a PDF file, any data that can be identified as a(n) ________ can be imported into Excel
• Which description matches Slowly Changing Dimensions Type 1?
• Which tab contains the tools for table design and is shown when a table is selected?
• Which statement correctly describes a snowflake schema relative to a star schema?
• Which pair of tabs appear only when a chart is selected?
• Which shortcut allows creating a new line within a single cell?
• One way to add headers and footers to a spreadsheet is to select Header & Footer in the _______ group on the Insert tab
• Which feature enables showing and hiding table rows based on criteria?
• Which statement about data lineage?
• Users can access the UNIQUE function through the Lookup & __________________ dropdown list in the Function Library group on the Formulas tab.
• In a pie chart, which element helps explain what each color or slice represents?
• The two common communication tools in Excel are called what?
• Which tool automatically fills in data based on a pattern?
• What is a role-playing dimension?
• A paste operation that converts columns to rows and vice versa is called what?
• The Chart Design and which tabs only display when a chart is selected?
• What is a lossless-join decomposition?
• What is a transitive dependency, and in which normal form is it removed?
• Why are surrogate keys preferred in data warehouses for dimension tables?
• Which statement describes a composite primary key?
• What term designates a specific part of a worksheet to print?
• What does a fact table store besides measures?
• What is the relationship between a superkey, a candidate key, and the primary key?
• In Excel, which feature helps locate specific elements within a worksheet?
• What are the common types of cardinality in relationships?
• What is a factless fact table?
• Conditional ______ changes the appearance of cells based on a set condition.
• Which operation toggles the data perspective from rows to columns?
• What is a derived attribute, and should it be stored in the physical model?
• Which term best describes the structure XML uses to organize data?
• Within the Page ______ view, you can see page margins, headers, and footers.
• How do you map an identifying relationship in an ERD to a relational schema?
• Which of the following best describes a fact table?
• Which function is accessed via the Lookup & Reference dropdown in the Formulas tab?
• Which feature would you enable to automatically total the numeric data at the end of the table's last column?
• To move a chart, you use Move Chart within the Location group on which tab?
• What does grain in a data warehouse fact table define?
• Data modeling reduces redundancy. What outcome does this promote?
• Which dropdown lets you adjust both row height and column width in the Home tab?
• The tools to insert and delete individual cells are located in which group on the Home tab?
• Which function would you use to generate a random integer within a specified range?
• Which action would you perform to locate elements such as formulas and comments in a worksheet?
• Which statement best describes candidate keys?
• Charts turn into images when exported and should include _______________ text for accessibility.
• What is a data dictionary, and what information does it typically contain?
• _________ is the spreadsheet app within Microsoft Office
• Excel automatically uses ________ as delimiters when importing a CSV file into Excel
• To remove a column in a table, you select the column, choose Delete, and then select which option?
• Which statement about natural keys is true?
• What is referential integrity?
• What is a surrogate key strategy in dimensional modeling?
• Which rule defines Boyce-Codd Normal Form (BCNF) and how is it stronger than 3NF?
• What is the definition of a primary key and its constraints in a relational model?
• Users can access the Find tool from the ______________ group under the Home tab
• The Quick Access Toolbar holds basic, frequently used ________.
• Which statement differentiates identifying relationships from non-identifying relationships?
• On which tab can you insert and manage columns and rows via the Cells group?
• The Alignment ______ presents users with more alignment options than the ribbon.
• Which option is an example of an atomic value?
• In BCNF, what defines a determinant?
• What is the difference between OLTP and OLAP data modeling considerations?
• The ______________ function is similar to the CONCAT function but allows for a common delimiter to be used in between pieces of text.
• Typically, data changes update automatically on a chart, but which changes do not automatically update?
• Explain the concept of normalization and its goal in relational databases.
• A chart ______________ provides an overall design look for a chart after a chart type is selected.
• Where is the Move Chart command located?
• What is a functional dependency?
• What is a primary key constraint?
• Users can access text formatting options for alignment, font formats, borders, and fill colors within the ________________ dialog box.
• Explain slowly changing dimensions Type 1, Type 2, and Type 3. Which statement accurately describes Type 2 behavior?
• The Find tool is found in which group under the Home tab?
• The ______________ function allows users to display data if a condition is true or false.
• Formatting cells with ___________ can add consistent formatting from file to file, helping people identify the data types on display.
• What is a factless fact table used for?
• On which tab is the Function Library group that contains the UNIQUE function located?
• What is the term for text used by screen readers to describe a chart?
• XML uses _________ to organize data
• The Clear Rules from ______ Sheet option within the Conditional Formatting dropdown menu allows users to clear many rules from a spreadsheet all at once.
• In a star schema, what is the relationship between the central table and the dimension tables?
• To keep headings in view, you can freeze both rows and columns with the ________ feature.
• Complete the sentence: The Format ____________ allows users to copy a format from one cell and paste it to another cell or cells.
• Normalization reduces redundancy and update anomalies.
• Which statement best describes the relationship between candidate keys and the primary key?
• The LOWER function converts text to _______________ capitalization.
• Which statement correctly describes normalization forms?
• Which function extracts a substring from the middle of a text string given a starting position and length?
• When printing a file, the default setting is for the ________ sheet to print.
• A partial dependency occurs when a non-key attribute depends on part of a candidate key. In which normal form is this condition eliminated?
• What is a foreign key?
• Metadata enables governance and understanding by describing which aspects?
• On which tab is the Tables group located to turn data into a table?
• What is the typical sequence for converting a conceptual model to a physical schema?
• Where can you display the Sort dialog box through the Custom Sort option?
• What does a bridge (junction) table typically contain?
• To access header and footer features, you would use the Header & Footer option on which tab?
• In the context of domain constraints, which element is used to define allowed values?
• In the Page Setup group, users can set their project's orientation to Portrait or ________
• In Excel, workbooks start with ________ worksheet(s) by default
• In the Table Style Options group, which checkboxes emphasize the first and last columns?
• What kind of data does a dimension table hold?
• Which type of names are restricted from starting with a number, containing spaces, or including cell references?
• What is a dimension table used for?
• ______ names cannot start with a number, have spaces, or contain cell addresses.
• What does dependency preservation mean in decomposition?
• Which statement most accurately describes the purpose of data modeling for OLTP and OLAP?
• Which statement about data types and domain constraints is true?
• RANDBETWEEN() generates a random number between two predetermined numbers. What best describes these numbers?
• What happens when you enable Show Formulas in a worksheet?
• What is the role of metadata in data modeling?
• What type of references should formulas use so that they adjust when copied or filled?
• What is referential integrity action on delete/cascade?
• Using Alt+Enter creates what type of text within a cell?
• Which term describes the small charts that fit in a single cell?
• How would you handle a multivalue attribute like multiple phone numbers in a relational model?
• What role does metadata play in governance and understanding of data?
• The Move or Copy Sheet option can be found in which tab and group?
• Which feature allows opening and viewing the same workbook in two separate windows?
• What is a foreign key and how does it enforce referential integrity?
• What is the term for the part of the worksheet designated to print a subset of the sheet?
• In an ER diagram, which element describes properties of an entity?
• Which term describes the look assigned to a chart after a type is chosen?
• Basic Excel formulas work well when adding, subtracting, multiplying, or dividing two or maybe three cells' worth of data. The majority of a user's Excel calculations are entered with ____________.
• Which chart type is commonly used to compare several data series across categories?
• Before saving a file as a template, delete data that will be replaced in a new version.
• Which chart type is best suited for comparing multiple series of data?
• Which activity ensures data types are appropriate during model development?
• After selecting a chart type, which feature defines the overall appearance of the chart?
• Two common communication tools in Excel are?
• Which feature offers a different perspective on data with multiple categories?
• Why is data modeling important for both OLTP and OLAP?
• Which function can be used to join multiple text pieces with a delimiter between them?
• It is a primary key composed of two or more columns that together guarantee uniqueness.
• Merging options are located in which group on the Home tab?
• What is the primary goal of normalization?
• Which feature helps maintain consistent formatting from file to file?
• When working with table styles, which dropdown arrow provides more options to customize the table's design?
• Link options are located on the ___________ tab
• To view cells with formulas, use Show Formulas within the Formula ________ group on the Formulas tab.
• Which approach enforces referential integrity in a relational database?
• The three elements users can add to a pie chart are a chart title, a(n) _____________, and data labels.
• All original values added to cells, whether text, numbers, or formulas, display in the ______ Bar when a cell is selected.
• Distinguish between simple, composite, and multivalued attributes; give an example.
• In which view would you adjust margins, headers, and footers for printing?
• Which type of data in a PDF is typically imported into Excel?
• Cells can be referenced in formulas by address or _____________ ranges.
• Which method is commonly used to enforce referential integrity in a relational database?
• Define 1NF, including what constitutes atomic values.
• What is a candidate key, and how does it differ from a primary key?
• Which command should you select to remove a column from a table?
• The ______ Accessibility feature is located in the Check for Issues dropdown list in the Backstage view.