An analyst is reviewing historical transaction data to discover relationships and items that frequently co-occur together. Which of the following methods describes this process?

• A) Clustering
• B) Verification
• C) Classification
• D) Association

A next-generation business intelligence tool uses machine learning algorithms to automatically scan data pools, isolate statistical anomalies, and generate summary text descriptions using natural language generation. This specific trend is known as:

• A) Self-Service BI
• B) Relational Data Mining
• C) Cloud-Based BI Solutions
• D) Augmented Analytics

After loading your source files into the system, it is vital to verify that the tables are linked properly. Which of the following features allows you to understand the structure and relationships between different fields?

• A) Table Viewer
• B) Script Editor
• C) Container Object
• D) List Box Selector

A developer needs to extract data directly from various source systems like ERP and CRM software. Which Microsoft platform tool is designated to pull this data or execute custom scripts?

• A) SQL Server Analysis Services
• B) Data Migration Assistant
• C) SQL Server Reporting Services
• D) SQL Server Integration Services

Professionals access business intelligence platforms from various locations using different hardware. Ensuring usability across desktops, tablets, and smartphones is achieved through which of the following?

• A) Responsive design
• B) Heavy data compression
• C) Manual page refreshing
• D) Text-only interfaces

Organizations routinely process proprietary information that requires strict perimeter shielding. Which of the following defines the primary purpose of user access control?

• A) To protect data from unauthorized access
• B) To automate predictive modeling tasks
• C) To optimize visual dashboard layouts
• D) To reduce storage capacity demands

Future demand and market prices are often unpredictable, requiring models that account for variability and uncertainty. Which of the following methods optimizes expected outcomes across different scenarios?

• A) Mixed Integer Programming
• B) Non-Linear Programming
• C) Stochastic Programming
• D) Integer Programming

Before training a fraud detection model, the available data is divided to ensure the model can be properly tested. Which of the following describes this process?

• A) Resampling the dataset
• B) Creating training and testing sets
• C) Encoding categorical variables
• D) Scaling numerical features

If a prescriptive model suggests actions that are operationally infeasible due to constraint violations, what is the most appropriate next step for the practitioner?

• A) Cease Data Integration
• B) Discard Model Findings
• C) Refine Constraint Parameters
• D) Archive Final Results

Developers often need to create custom data integrations or embed a platform's capabilities into external applications. Which of the following features allows for this custom access?

• A) API Access
• B) LookML code layers
• C) Drag-and-drop layouts
• D) Centralized definitions

To safely bridge the gap between cloud-based Power BI Services and on-premises organizational data structures, which architecture component acts as the secure intermediary?

• A) Power BI Desktop
• B) Premium Student License
• C) Power BI Gateways
• D) Power BI mobile apps

To track financial outlays alongside audience interaction metrics, which metric must be featured on the campaign performance dashboard?

• A) Total Profit
• B) Total Margin
• C) Total Discount
• D) Total Cost

A company ingests logs, PDFs, IoT streams, and ERP tables without predefined schema. Which architecture best supports this requirement?

• A) Stream Processing Platform
• B) Data Warehouse
• C) Data Lake
• D) Relational Database

Medical researchers processed the gathered clinical datasets to anticipate how different care pathways would impact long-term recovery. Which of the following analytical methods was used to forecast patient outcomes based on various treatment plans?

• A) Qualitative surveying
• B) Retrospective auditing
• C) Predictive modeling
• D) Descriptive modeling

Making informed strategic decisions requires a thorough understanding of potential outcomes. Which combination of methodologies provides this level of insight?

• A) Hardware and Software Integration
• B) Email and Chat Synchronization
• C) Simulation and Scenario Planning
• D) Text and Audio Transcription

A database administrator wants to connect a cloud-based visual analytics platform to managed relational databases hosted specifically on Amazon Web Services. Which database pairing is natively supported in this AWS tier?

• A) PostgreSQL and MySQL
• B) Redshift and SQL Server
• C) PostgreSQL and SQL Server
• D) Redshift and Snowflake

Which BI component enables users to visualize KPIs and interactively explore trends?

• A) Interactive dashboard
• B) ETL pipeline
• C) Backup log
• D) Data warehouse schema

Effective inventory management requires a specific calculation to measure how often stock is sold and replaced. Which of the following represents the formula for Inventory Turnover?

• A) COGS/ Avg Inventory
• B) Sales + Inventory
• C) Revenue - Costs
• D) Profit / Inventory

Prescriptive analytics builds upon specific inputs to generate its final recommendations. Which of the following serves as that primary input?

• A) Raw Metadata
• B) Predictive Outputs
• C) Legacy Hardware
• D) User Surveys

You are tasked with creating a visualization that maps out the customer base across two specific continuous metrics: Purchase Frequency and Average Order Value. Which of the following chart types should you build?

• A) Treemap
• B) Pie Chart
• C) Scatter Plot
• D) Bar Chart