Exam Certified Platform Developer II topic 1 question 58 discussion

SELECT COUNT() is the correct answer (D). Tested with a Case object containing 7 millions of records

Aditya97 I think D. COUNT() could be right because: Queries that include aggregate functions are still subject to the limit on total number of query rows i.e 50,000. All aggregate functions other than COUNT() or COUNT(fieldname) include each row used by the aggregation as a query row for the purposes of limit tracking. For COUNT() or COUNT(fieldname) queries, limits are counted as one query row, unless the query contains a GROUP BY clause, in which case one query row per grouping is consumed.

Count is the answer

Count should be used in an aggregate SOQL

SELECT COUNT() is the correct answer (D).

The answer is D. Using the basic COUNT() function returns an integer, not an aggregate result, so there is even less code to write. Also, the limit is on the number of rows retrieved, not queried against. https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_count.htm https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_SOQL_agg_fns.htm

Ans is d => https://help.salesforce.com/s/articleView?id=release-notes.rn_apex_soql_count_limits.htm&type=5&release=214

Should be A, as COUNT() hits the limits of 50k records. https://metillium.com/2016/05/soql-50000-record-limit-applies-with-count/

D is the correct answer without any doubt. Count() only contributes as 1 SOQL query.

I also think D is correct according to this source https://help.salesforce.com/s/articleView?id=release-notes.rn_apex_soql_count_limits.htm&type=5&release=214

Correct answer should be A as there are millions of Opportunities and COUNT() will hit limit t 50000 records.