Oracle

 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...

 Question #29 Topic 1 HOTSPOT -  You have a folder of monthly transaction extracts. You plan to create a report to analyze the transaction data. You receive the following email message: `Hi, I've put 24 files of monthly transaction data onto the shared drive. File Transactions201801.csv through Transaction201812.csv have four columns while files Transactions201901.csv through Transaction201912.csv have the same four columns plus an additional three columns. Each file contains 10 to 50 transactions.` You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.) x  https://www.examtopics.com/exams/microsoft/da-100/custom-view/ 26/169  The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected. Box 3: Yes - Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manu...

 You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: ✑ Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. ✑ Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function. B. Create one-to-many relationships between the tables. C. Create a calculated measure that aggregates by using the COUNTROWS function. D. Create a calculated table that contains Ad_id, Site_name, and Impression_date. Correct Answer: AB Community vote distribution AB (83%) U (17%) 2/16/22, 10:49 PM DA-100 Exam – Free Actual Q&As, Page 1 | ExamTopics https://www.examtopi...

 difference between package/function/procedure what is mutation error can we create index on views/mviews Types of exception/pragma Types of trigger If i have null values. what inner join returns/outer join returns

 1:- On which column we need to create index 2 :- Index depends on workload then on column 3:- For example if DEPTNO and DEPTNAME  is available then index need to be created on deptno and deptname 4:- Index to avoid sorting (group by and order by), to improve sorting ,which can improve performance 5 :- Create index for uniqueness 6 :- Create index for foreign key 7:- Be aware of modification on applications