MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Overall MCQs for Reference

Which type of custom table calculation aggregates data across time ranges in AI dashboards?
a. Calculated dimension
b. Calculated measure
c. String function
d. Boolean field
Answer: b. Calculated measuredatabricks+1
What is a primary advantage of custom table calculations over static datasets?
a. They always require SQL changes
b. They dynamically adjust to user-applied filters
c. They only support one type of function
d. They cannot be reused
Answer: b. They dynamically adjust to user-applied filtersdatabricks+1
When writing a custom calculation in most AI dashboards, which formula shows the margin percentage?
a. SUM(Cost)/SUM(Price)
b. (SUM(Price) – SUM(Cost))/SUM(Price)
c. SUM(Price)/SUM(Cost)
d. SUM(Price) + SUM(Cost)
Answer: b. (SUM(Price) – SUM(Cost))/SUM(Price)databricks+1
Which of the following data types can table calculations process?
a. Only numbers
b. Numbers, text, date, boolean
c. Only strings
d. Only dates
Answer: b. Numbers, text, date, booleantalkdesk+2
How do custom table calculations differ from regular fields in query logic?
a. They change database schema
b. They operate after data retrieval
c. They cannot use functions
d. They are created only by database admins
Answer: b. They operate after data retrievaltalkdesk
What is a limitation of sorting on custom table calculations?
a. Sorting always works
b. Sorting is disabled for order-dependent calculations
c. They never show in reports
d. Sorting is random
Answer: b. Sorting is disabled for order-dependent calculationstalkdesk
Which function could you use for calculating running totals in table calculations?
a. COUNT
b. RUNNING_SUM
c. MAX
d. CEILING
Answer: b. RUNNING_SUMtableau
In most tools, what syntax is used for custom formulas generated by AI?
a. SQL
b. SQLite
c. Visual Basic
d. HTML
Answer: b. SQLiteatlassian
Why must all fields used in a table calculation be part of the initial query?
a. For security
b. Because table calculations only work on retrieved data
c. To prevent duplication
d. To ensure indexing
Answer: b. Because table calculations only work on retrieved datacloud.google
What formatting rule should be followed for decimal numbers in most calculation editors?
a. No formatting required
b. Always include leading zeroes (e.g., 0.95)
c. Use commas
d. Omit decimal points
Answer: b. Always include leading zeroes (e.g., 0.95)cloud.google
Which calculation type is best for categorizing age ranges in a dataset?
a. Calculated measure
b. Calculated dimension
c. Default column
d. Hidden field
Answer: b. Calculated dimensiondatabricks+1
Which table calculation would produce Boolean True/False results?
a. Logical function
b. String concatenation
c. Min function
d. Aggregate function
Answer: a. Logical functionpartner.cloudskillsboost+2
In Looker, which dialog is used to create table calculations?
a. Explore
b. Custom Fields
c. Data Source
d. Dashboard Settings
Answer: b. Custom Fieldscloud.google
What must you do to sort by a custom table calculation?
a. Click the field name at the column top
b. Reload data
c. Export table
d. Rebuild dashboard
Answer: a. Click the field name at the column toptalkdesk
To calculate profit in a table, which function is mostly used?
a. SUM()
b. AVG()
c. CONCAT()
d. TRUE()
Answer: a. SUM()databricks+1
Which scenario requires increasing the row limit in table calculations?
a. If query has fewer rows than limit
b. If sorting custom calculation fails due to row cap
c. If formatting decimals
d. If using only text fields
Answer: b. If sorting custom calculation fails due to row capcloud.google+1
What kind of transformation could custom table calculations perform?
a. Complex string manipulation
b. Date conversion
c. Both a and b
d. None
Answer: c. Both a and bpartner.cloudskillsboost+2
What’s an important native limitation for AI-generated custom formulas in Atlassian Analytics?
a. Cannot reference multiple columns
b. Only affect a single column at a time
c. Only support number data type
d. No formatting allowed
Answer: b. Only affect a single column at a timeatlassian
Which statement about filtering columns using AI-generated custom formulas is correct?
a. Supported
b. Not supported
c. Partially supported
d. Supported only in Pro version
Answer: b. Not supportedatlassian
Which step is NOT part of creating a custom calculation in Power BI?
a. New table
b. Enter formula
c. Apply visualization
d. Add calculated row using DAX
Answer: d. Add calculated row using DAXlearn.microsoft
In many BI tools, what does clicking “Save” after creating a calculation do?
a. Deletes old calculations
b. Stores calculation to data table
c. Sends calculation to the server
d. Exports as report
Answer: b. Stores calculation to data tablelearn.microsoft+1
What is the effect of Ctrl+K in Looker while editing table calculations?
a. Deletes all fields
b. Clears all table calculations
c. Exports report
d. Recalculates all values
Answer: b. Clears all table calculationscloud.google
For aggregation functions in table calculations, which is valid?
a. AGGREGATE OVER
b. AGGREGATE_NEXT
c. AGGREGATE SUM
d. AGGREGATE MIN
Answer: a. AGGREGATE OVERdatabricks+1
What does a calculated measure represent?
a. Raw column
b. Aggregated value
c. Unaggregated value
d. Data type
Answer: b. Aggregated valuedatabricks+1
Which step allows renaming custom table calculations in most dashboards?
a. Enter a new calculation name
b. Refresh data
c. Auto-generate name
d. No option available
Answer: a. Enter a new calculation namecloud.google
Which function allows you to calculate the difference between two dates?
a. CONCATENATE
b. DATE_DIFF
c. TRUE_FALSE
d. CEILING
Answer: b. DATE_DIFFatlassian
When creating a conditional statement in table calculations, which syntax might you use?
a. IF()
b. CASE WHEN
c. Both a and b
d. LOOP()
Answer: c. Both a and batlassian+1
Which editor is commonly used for building custom table calculations in Looker?
a. JSON editor
b. Expression editor
c. Report editor
d. Console
Answer: b. Expression editorcloud.google
Why do custom table calculations only reflect values in displayed rows?
a. They operate on query results shown
b. They change database schema
c. They overwrite measures
d. They use SQL directly on source
Answer: a. They operate on query results showntalkdesk+1
What is one benefit of custom table calculations for quick business logic changes?
a. Requires admin approval
b. Anyone can define new metrics instantly
c. Requires editing database views
d. Needs to be coded in Python
Answer: b. Anyone can define new metrics instantlytalkdesk
Which calculation could convert “Original time estimate (seconds)” to hours?
a. seconds/3600
b. seconds*60
c. seconds/60
d. seconds+3600
Answer: a. seconds/3600atlassian
What kind of expression could change the format of “Date column” to MM-YYYY?
a. FORMAT(Date, ‘YYYY-MM’)
b. FORMAT(Date, ‘MM-YYYY’)
c. CHANGE_FORMAT(Date, ‘YYYY-MM’)
d. FORMAT(Date, ‘DD-YYYY’)
Answer: b. FORMAT(Date, ‘MM-YYYY’)atlassian
What column type appears after a custom table calculation is added in Looker?
a. Green column
b. Blue column
c. Orange column
d. Yellow column
Answer: a. Green columntalkdesk
In Looker, what is NOT supported by table calculations when total row is added?
a. mean aggregation
b. percentile calculation
c. both a and b
d. concatenation
Answer: c. both a and bcloud.google
Which shortcut can clear all custom calculations in Looker on Windows?
a. Ctrl + C
b. Ctrl + X
c. Ctrl + K
d. Ctrl + S
Answer: c. Ctrl + Kcloud.google
In data visualization tools, which command is used to create a new formula column?
a. Add Formula
b. New Calculation
c. Apply Formula
d. All of the above
Answer: d. All of the aboveatlassian
What is a string function example in table calculations?
a. CONCAT(“First name”, “Last name”)
b. SUM(Cost)
c. DATE_DIFF
d. RUNNING_SUM
Answer: a. CONCAT(“First name”, “Last name”)partner.cloudskillsboost
Which category does ROUND(“Column”, 2) belong to?
a. String transformation
b. Mathematical calculation
c. Logical operation
d. Date operation
Answer: b. Mathematical calculationpartner.cloudskillsboost+1
What expression could provide the first ten characters of a string column via custom calculation?
a. LEFT(“Column”, 10)
b. MID(“Column”, 10)
c. RIGHT(“Column”, 10)
d. SUBSTRING(“Column”, 10)
Answer: a. LEFT(“Column”, 10)atlassian
Which step is necessary before you can use table calculations in a data table?
a. Ensure all required fields are in the query
b. Add to dashboard
c. Restart the app
d. Import new data
Answer: a. Ensure all required fields are in the querycloud.google
What is a calculated table in Power BI primarily used for?
a. Importing external data
b. Storing results of table expressions
c. Formatting visuals
d. Replacing columns
Answer: b. Storing results of table expressionslearn.microsoft
When writing custom calculations in Lightdash, what syntax is used?
a. Raw SQL
b. JSON
c. YAML
d. XML
Answer: a. Raw SQLlightdash
What happens if you try to run a custom calculation on more rows than the UI row limit?
a. It processes all rows anyway
b. It only calculates with rows available in the UI
c. It throws a critical error
d. It returns blank
Answer: b. It only calculates with rows available in the UItalkdesk+1
Table calculations in AI can be used for which types of business analysis?
a. Profit margin
b. Categorization
c. Date difference
d. All of the above
Answer: d. All of the abovedatabricks+2
Which type of table calculation would you use for “if column contains ‘XYZ’ then value X else value Y”?
a. Logical
b. Mathematical
c. Date-based
d. String
Answer: a. Logicalatlassian
In custom table calculations, what is the main difference between calculated measures and calculated dimensions?
a. Measures are unaggregated; dimensions are aggregated
b. Measures are aggregated; dimensions are unaggregated
c. Both are aggregated
d. Both are unaggregated
Answer: b. Measures are aggregated; dimensions are unaggregateddatabricks+1
What’s recommended for users wanting to reuse table calculations later?
a. Save report or copy formula elsewhere
b. Export to PDF
c. Screenshot dashboard
d. Use default settings
Answer: a. Save report or copy formula elsewheretalkdesk
Which expression converts a string column to a numeric data type?
a. TO_NUMBER(“Column”)
b. ROUND(“Column”)
c. FORMAT(“Column”)
d. LENGTH(“Column”)
Answer: a. TO_NUMBER(“Column”)atlassian
Table calculations are commonly featured in which popular data tools?
a. Power BI
b. Looker
c. Tableau
d. All of the above
Answer: d. All of the abovetableau+2
Which is NOT a function typically performed by custom table calculations?
a. Filtering columns
b. Aggregating numeric data
c. Formatting dates
d. Creating conditional fields
Answer: a. Filtering columnsatlassian

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info