Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Certified Platform Data Architect (Plat-Arch-201) Exam - Topic 3 Question 9 Discussion

Actual exam question for Salesforce's Salesforce Certified Platform Data Architect (Plat-Arch-201) exam
Question #: 9
Topic #: 3
[All Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions]

The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:

Select id, description, Subject from Task where WhatId != NULL

When the data architect usages the query to select values for a process a time out error occurs.

What does the data architect need to change to make this query more performant?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Talia at Oct 22, 2022, 03:34 PM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rolland
5 months ago
Wait, can you really use NULL like that in SOQL?
upvoted 0 times
...
Van
6 months ago
Definitely need to filter by a specific value.
upvoted 0 times
...
Chery
6 months ago
Changing to SOSL? Not sure that’s the right move.
upvoted 0 times
...
Jerry
6 months ago
I think adding a limit is a good idea!
upvoted 0 times
...
Albina
6 months ago
The query should use "WhatId = NULL" instead.
upvoted 0 times
...
Fernanda
6 months ago
I feel like filtering by a specific value could improve performance, but I’m not entirely sure how that would apply here.
upvoted 0 times
...
Sharmaine
6 months ago
Changing to SOSL seems like a drastic step, but I don't recall if it would actually help in this case.
upvoted 0 times
...
Aliza
6 months ago
I think I saw a similar question where adding a limit helped with performance. Maybe option C is the right choice?
upvoted 0 times
...
Trinidad
7 months ago
I remember something about using NULL in SOQL can lead to performance issues, but I'm not sure how to fix it.
upvoted 0 times
...
Aretha
7 months ago
Okay, let's see here. I think the key is to look for any issues with the EPM Agent configuration or settings that could be causing the problem.
upvoted 0 times
...
Marquetta
7 months ago
Hmm, I'm a bit confused about the esxtop tool and how to capture the data properly. Do we need to log in to the ESX Server machine and run esxtop interactively? Or is there a way to do it in batch mode to get the CSV output?
upvoted 0 times
...
Corinne
7 months ago
This question seems straightforward, but I want to double-check my understanding. I'll review the HA guidance one more time before selecting my answer.
upvoted 0 times
...
Cammy
7 months ago
This is a good test of our understanding of cryptographic principles. I'll use the process of elimination to narrow down the options and arrive at the correct answer.
upvoted 0 times
...
Mel
7 months ago
Hmm, I'm not sure about this one. I know we can save forms in Access, but I'm not sure if we can directly convert them to reports. I'll have to think this through carefully.
upvoted 0 times
...
Carmen
7 months ago
Option D sounds like the way to go. Using a CDN to cache and serve the images should give me the low latency I need, and Cloud Storage is a reliable and cost-effective way to store them. I feel pretty confident about this one.
upvoted 0 times
...

Save Cancel