- All Exams Instant Download
FOR Month IN (January, February, March, April, May, June, July, August, September, October, November, December))
FOR Month IN (January, February, March, April, May, June, July, August, September, October, November, December)) AS MonthNamePivot View AnswerAnswer: 1 SELECT * FROM 2 (SELECT YEAR(SalesData)) AS Year, DATENAME (MONTH, SalesDate) AS Month, SalesAmount AS Amount 3 FROM Products.Sales 4 ) AS MonthlySalesData 5 PIVOT SUM(Amount) 6 FOR Month IN...
Which of the following tasks are MOST appropriate for the hardening process?
A cloud service provider wants to offer hardened virtual server images for provisioning purposes. This will enable users to use only the operating system services that are allowed by the provider. Which of the following tasks are MOST appropriate for the hardening process? (Select TWO).A . Disable automatic updates.B ....
Which of the following methodologies should be selected?
A system's application servers need to be patched. The requirements for maintenance work are as follows: - System downtime is not allowed. - The application server in use must be in the sane patch status. - System performance must be maintained during patching work. - Testing after patching must be...
Which of the following is the BEST approach to resolve the issue?
A cloud administrator reports a problem with the maximum number of users reached in one of the pools. There are ten VMs in the pool, each with a software capacity to handle ten users. Based on the dashboard metrics, 15% of the incoming new service requests are failing. Which of...
Which of the following solutions would BEST meet these requirements?
A storage administrator must choose the best replication methodology for storage. - The datacenters are on opposite sides of the country. - The RPO is 24 hours. - Replication and customer access use the same connections. - Replication should not impact customer access during the day. Which of the following...
Given the information above, which of the following should a cloud administrator do to BEST accommodate failover and redundancy requirements?
A company has deployed a four-node cluster in a COLO environment with server configurations listed below. The company wants to ensure there is 50% overhead for failover and redundancy. There are currently eight VMs running within the cluster with four vCPUs x32GB each. The company wants to better utilize its...
Which of the following is the BEST solution to implement to minimize future alerts?
A cloud administrator is receiving alerts that the disk on several systems is 90% full. Upon reviewing the systems, the administrator determines that the log directory is using 50% of the disk. The company has a 14-day retention policy for all logs. Which of the following is the BEST solution...
Which of the following is the BEST way to ensure accounts in a cloud environment are disabled as soon as they no longer need to be active?
Which of the following is the BEST way to ensure accounts in a cloud environment are disabled as soon as they no longer need to be active?A . Have the user contact the cloud systems administrator to disable the account when it is no longer needed.B . When users leave...
Which of the following is the MOST efficient way to get the patches installed?
The CSA needs to install a patch on 58 virtual server instances during the Friday evening maintenance window. Which of the following is the MOST efficient way to get the patches installed?A . Use the patch management tool to automate and orchestrate the patch installation.B . Use a security vulnerability...
Which of the following tools should a cloud administrator deploy to meet this requirement?
A cloud administrator notices one of the servers is using the wrong set of NTP servers. The administrator needs to avoid the same issue in the future but needs to minimize administration resources. Which of the following tools should a cloud administrator deploy to meet this requirement?A . Patching toolsB...
