DS0-001 exam

Over the weekend, a company’s transaction database was moved to an upgraded server. All validations performed after the migration indicated that the database was functioning as expected. However, on Monday morning, multiple users reported that the corporate reporting application was not working. Which of the following are the most likely...

A database administrator wants to remove inactive customers from a database. Which of the following statements should the administrator use? A) B) C) D) A. Option A B. Option B C. Option C D. Option DView AnswerAnswer: A Explanation: The statement that the administrator should use to remove inactive customers...

Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?A . Split the load size into many transactions.B . Split the load size in half and run simultaneously.C . Batch into small loads and run in...

A database administrator wants to remove inactive customers from a database. Which of the following statements should the administrator use? A) B) C) D) A. Option A B. Option B C. Option C D. Option DView AnswerAnswer: A Explanation: The statement that the administrator should use to remove inactive customers...

A programmer wants to configure a database to only allow read or write access when requests are coming from specific IP addresses. Which of the following can be used to configure IP addresses to allow access to the database?A . Static IP addressB . FirewallC . Dynamic IP addressD ....

A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company’s transactional data. Which of the following tasks should the administrator perform first?A . Create a new service account exclusively for the business intelligence application.B . Build a separate data warehouse customized to...

A DBA is reviewing the following logs to determine the current data backup plan for a primary data server: Which of the following best describes this backup plan?A . Monthly full, daily differentialB . Daily differentialC . Daily fullD . Weekly full, daily incrementalView AnswerAnswer: D Explanation: The backup plan...

A database administrator wants to remove inactive customers from a database. Which of the following statements should the administrator use? A) B) C) D) A. Option A B. Option B C. Option C D. Option DView AnswerAnswer: A Explanation: The statement that the administrator should use to remove inactive customers...

Which of the following scripts would set the database recovery model for sys.database? A) B) C) D) A. Option A B. Option B C. Option C D. Option DView AnswerAnswer: A Explanation: The script that would set the database recovery model for sys.database is option A. This script uses the...

Which of the following is a result of an on-path attack on a system?A . A Wi-Fi network that redirects to clones of legitimate websitesB . A website that has crashed and is no longer accessibleC . An email from an unknown source requesting bank account detailsD . A web...