Data provided by Consolidated Messenger is cached in the HttpContext.Cache object. You need to ensure that the cache is correctly updated when new data arrives. What should you do?
A.
Ensure that the EffectivePrivateBytesLimit value is greater than the size of the database file.
B.
Change the sliding expiration of the cache item to 12 hours.
C.
Use the SqlCacheDependency type configured with a connection string to the database file.
D.
Use the CacheDependency type configured to monitor the SFTP target folder.
The dependency is on a folder where the backup is dropped (even if not indicated explicitly, it is logical). When something in the folder changes, i.e. a new db backup is dropped, the cache is invalidated. I also believe that the answer is D.
Yes I also think it answer D, because CacheDependency will monitor a single file, folder or an array of files and folders for changes. The content of the file is less relevant, because the file is read by your own custom code.
string fileContent = Cache["AccessFile"] as string;
if (string.IsNullOrEmpty(fileContent))
{
//Method that reads Access DB, could return string or Dataset
fileContent = ReadAccessDB(pathToAccessDBFile);
Cache.Insert("AccessFile", fileContent, new CacheDependency(Server.MapPath(pathToAccessDBFile)));
}
Answer should be C I believe. The question says "The service retrieves flight information from a number of sources and combines them into a single data set. The consolidated flight information is stored in a SQL Server database. " ... so the data received from various sources, in various formats (Access etc.) ends up consolidated in a SQL database by the service we are building. When new data is written to the database the SqlCacheDpendency can update the cache.
SqlCacheDependency is not suportted by Microsoft Access, so answer C is not an option:
"Cache dependency is not supported by Microsoft Access, and any access to the SqlCacheDependency property results in a NotSupportedException exception."
Ref: https://docs.microsoft.com/en-us/dotnet/api/system.web.ui.webcontrols.accessdatasource.sqlcachedependency?view=netframework-4.8
https://docs.microsoft.com/pt-br/dotnet/api/system.web.ui.webcontrols.accessdatasource.sqlcachedependency?view=netframework-4.8
Don't think that D is correct. Only one Provider uses SFTP to provide data every 12 Hours and that is only one part of the Consolidated data wich is stored in and and retrieved from the database.
So i would go with C by using SQLCacheDependency.
Consolidated Messenger not Consolidated data . i think D is correct
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.70-487 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tokyohanuman
Highly Voted 5 years, 3 months agoklassanov
4 years, 10 months agoDreamchaser1980
4 years, 8 months agosti88
Most Recent 4 years, 7 months agozimzimzimma
4 years, 8 months agoE123456789
4 years, 8 months agoviniventura
5 years, 1 month agoC0unt23r0
5 years, 5 months agoSanfour
4 years, 11 months ago