Oracle

 

  You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements: ✑ Ensure that all traffic to the public endpoint of SqlSrv1 is blocked. ✑ Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.  What should you create on VNet1?  A. a VPN gateway  B. a service endpoint  C. a private link  D. an ExpressRoute gateway  Correct Answer: C  You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server. You need to ensure that each customer can only connect to and access their respective database. Which two actions should you perform? Each correct answer presents part of the solution.  NOTE: Each correct selection is worth one point. A. Imp...

 Question #1 Topic 1 You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. total size of all the databases B. geo-replication support C. number of concurrently peaking databases * peak CPU utilization per database D. maximum number of concurrent sessions for all the databases E. total number of databases * average CPU utilization per database Correct Answer: ACE  CE: Estimate the vCores needed for the pool as follows: For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X Peak vCore utilization per DB) A: Estimate the storage space needed for the pool by adding the number of bytes needed for ...

 

 You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?  A. donut chart  B. pie chart  C. area chart  D. scatter plot  Correct Answer: D  Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily.  Reference:  https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc You need to create a visual as shown in the following exhibit. The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only. How should you configure the visual? To answer, select the appropriate   In the Background color or Font color dialog box, select Field value from the Format by drop-do...

  1->   How to create one to one relationship. Answer-> https://www.tutorialspoint.com/One-to-One-Relationship-in-DBMS#:~:text=One%2Dto%2DOne%20relationship%20in%20DBMS%20is%20a%20relationship%20between,of%20an%20entity%20with%20another.&text=An%20Employee%20is%20issued%20an,Card%20(ID_Card)%20are%20entities. One-to-One relationship  in DBMS is a relationship between an instance of an entity with another. An Employee is issued an Employee ID Card. An individual employee is offered a unique ID card in the company.  Here,  Employee  and I D Card (ID_Card)  are entities. A One-to-Many Unary Relationship is the association with the same entity between the same instances represented by different role groups. Consider the relationship between Managers and Employees.The two different Roles in this relationship are- Managers and Employees. Only few Employees take the role of Managers within an organization while everyone working for an organizat...