Practice free. Pass with confidence.
Free, community-shared practice questions for AWS, Microsoft, CompTIA, Cisco, and more — organized with AI, explained in plain language, with instant feedback. No signup required to start.
Browse by provider
10 providers · 106 exam banksLatest exam question analyses
View all updates →-
DP-700
OneLake availability for an eventhouse copies only newly ingested data by default
When you turn on OneLake availability for an eventhouse in Microsoft Fabric, only data added to the eventhouse after the feature is enabled is made available in OneLake; existing tables are not
-
DP-700
Grant analysts gold-layer access by sharing the lakehouse with Read all SQL Endpoint data
Sharing the gold-layer lakehouse with the DataAnalysts group and granting Read all SQL Endpoint data gives T-SQL read access to its Delta tables without exposing the bronze and silver layers or the
-
MS-700
Teams Shared Channel External Collaboration for Marketing
Teams shared channels for external collaboration require enabling 'Invite external users to shared channels' on the specific department's Teams policy and configuring B2B direct connect inbound
-
MS-700
Why can't a chat recipient open a file shared in Teams?
When a file shared in a Teams chat returns "You don't have access to this file" even though the recipient was granted access, the cause is the Limited-access user permission lockdown mode site
-
PL-300
PREVIOUSYEAR returns the full previous year, not the same day of last year
A card visual shows a Previous Year Sales measure using CALCULATE with PREVIOUSYEAR while the report page filters to May 9, 2024, so the displayed value depends on exactly which dates PREVIOUSYEAR
-
PL-300
Shrinking a Power BI model for monthly transaction totals with a star schema
A semantic model with Date, Account, and Transactions tables must show monthly transaction totals for the current and prior year, follow a star schema, and minimize model size, with three actions to
-
SC-200
Why increasing audit-search record count does not fix missing JSON columns in Excel
When Excel's Get & Transform fails to create columns for specific JSON properties in an audit export, increasing the number of returned records does not help, because Power Query derives columns only
-
SC-200
Reducing rows before the JSON transform so Excel generates the needed audit columns
To make Excel create columns for specific JSON properties in an audit export, you reduce the number of rows (for example by filtering) so that records containing those properties fall within the
-
SC-100
Using Microsoft Entra Permissions Management to find unused RBAC assignments
To identify which RBAC role assignments across 10 subscriptions were not used in the last 90 days with minimal effort, use Microsoft Entra Permissions Management, whose analytics reveal unused
-
SC-100
Applying customer-managed key encryption at the file level in Data Lake Storage
To apply customer-managed keys with service-side encryption at the most granular level in Azure Data Lake Storage, use encryption scopes at the file (blob) level, since scopes can be set per
-
PL-400
Choosing a component library for the City Power & Light Suitability Assessment Tool
City Power & Light wants the Suitability Assessment Tool's UI built from modular components that other applications can reuse.
-
PL-400
Selecting Azure Logic Apps to orchestrate the City Power & Light Planning Hub workflow
After an assessor submits a funding application, the Planning Hub must retrieve details, send a Teams approval to a senior manager, upload to a REST API with retry, and email on failure.
Most discussed questions
Community debate, expert analysis & FAQs-
SY0-701
Which Term Describes a Legacy Device Stopping Patch Updates?
This question tests CompTIA’s standardized definitions for product lifecycle stages, specifically distinguishing End of Life (EOL) from End of Support (EOS). While enterprise vendors sometimes separate these phases, CompTIA treats EOL as the definitive point when a device is retired and ceases all updates, patches, and vendor assistance.
-
SY0-701
Which Zero Trust Component Is Most Relevant for the Data Plane?
This question tests the candidate's ability to distinguish between control plane and data plane functions in a Zero Trust architecture. Community consensus confirms that evaluating subject roles is the primary data plane task for enforcing least privilege during live access execution.
-
DP-600
Displaying All Rows in Power BI Python Visuals
This page explains how to prevent automatic grouping in Power BI Python visuals by adding a unique identifier field, ensuring all rows including duplicates are displayed.
-
DP-600
Identifying Max Values for Numeric Columns in Power Query
This question tests the correct Power Query M function for analyzing numeric columns to find maximum values. The page establishes that Table.Profile is the intended answer for generating a statistical summary of all columns.
-
PL-300
Connecting Power BI Desktop to Azure DevOps Analytics views with the OData Feed connector
A bug tracking dashboard must consume Azure DevOps Analytics views from the cloud with server-side filtering, so Power BI Desktop must be pointed at the connector that reads those views directly.
-
SY0-601
Mobile Data Security After Device Theft
This question addresses the best technical control to protect data on a stolen mobile device when credentials are compromised. Containerization is identified as the correct solution to isolate corporate data from personal storage.